Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Formula


10 Mar 2014   #1

Windows 7 64 bit
 
 
Excel Formula

Hello Sir,
Can you let me know the formula in Excel:
I have a table as below:
Name:  2345.PNG
Views: 32
Size:  2.0 KB


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 System SpecsSystem Spec
.

11 Mar 2014   #2

Windows 7 ultimate x64
 
 

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 System SpecsSystem Spec
11 Mar 2014   #3

Windows 7 64 bit
 
 

Dear archer,
I follow your way and I got the result "FALSE" when i put "Completed"
Thanks
My System SpecsSystem Spec
.


11 Mar 2014   #4

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Quote   Quote: Originally Posted by yimveasna View Post
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 System SpecsSystem Spec
Reply

 Excel Formula




Thread Tools



Similar help and support threads for2: Excel Formula
Thread Forum
Solved Excel custom formula Help Microsoft Office
Solved Excel 2003 sum formula problem Microsoft Office
Solved Want to copy data and formula from one Excel Sheet to another. Microsoft Office
Excel Formula Help please... Microsoft Office
Cant scroll while editing formula Excel 2007 Microsoft Office

Our Sites

Site Links

About Us

Find 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 05:40 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33