Excel Formula


  1. Posts : 14
    Windows 7 64 bit
       #1

    Excel Formula


    Hello Sir,
    Can you let me know the formula in Excel:
    I have a table as below:
    Excel Formula-2345.png


    This table, At the column "A,Status" when i Put the word" Completed", it's will automatic put current Date to Column "B, Row 2".
    But i don't know after that when tomorrow arrived,at the column "B,Row 2", change date too.
      My Computer


  2. Posts : 7,379
    Windows 7 ultimate x64
       #2

    Hi,

    Use this one, in the next line
    3.
    "=IF(A:A="Complete",B2+1)"

    With this one, when you enter "Complete" in A3, it will automatically put the date in B3.
      My Computer


  3. Posts : 14
    Windows 7 64 bit
    Thread Starter
       #3

    Dear archer,
    I follow your way and I got the result "FALSE" when i put "Completed"
    Thanks
      My Computer


  4. Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       #4

    yimveasna said:
    Dear archer,
    I follow your way and I got the result "FALSE" when i put "Completed"
    Thanks
    That's because you have not provided a value for the false outcome

    IF(condition, true, false).

    So..

    =IF(A:A="Complete",B2+1,"")

    Will will give you a null instead of the FALSE.

    Tanya
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 04:40.
Find Us