+ Reply to Thread
Results 1 to 4 of 4

If formula needed

  1. 02-27-2012, 12:48 AM #1
    senjuti.sarkar
    senjuti.sarkar is offline
    Registered User
    Join Date
    12-31-2011
    Location
    West Bengal
    MS-Off Ver
    Excel 2007
    Posts
    76

    If formula needed

    Dear Friends,

    I need a Formula for IF CELL C38=FILED WORK, THEN CELL C37 WILL COUNT 1.

    How could I do this?

    Thanks in advance..

    Senjuti
    Last edited by senjuti.sarkar; 02-27-2012 at 12:59 AM.
    Reply With QuoteRegister To Reply
  2. 02-27-2012, 12:54 AM #2
    helpwantedd
    helpwantedd is offline
    Registered User
    Join Date
    02-27-2012
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: If formula needed

    I am guessing you are putting this in cell C37...

    IF(C38="FILED WORK",1,"")
    Reply With QuoteRegister To Reply
  3. 02-27-2012, 12:55 AM #3
    DGagnon
    DGagnon is offline
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: If formula needed

    in cell C37 try:

    =IF(C38="Filed Work",1,0)
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
    Reply With QuoteRegister To Reply
  4. 02-27-2012, 12:59 AM #4
    senjuti.sarkar
    senjuti.sarkar is offline
    Registered User
    Join Date
    12-31-2011
    Location
    West Bengal
    MS-Off Ver
    Excel 2007
    Posts
    76

    Re: If formula needed

    Thanks for the prompt reply, both the formula worked.

    Thanks once again.

    Senjuti
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1