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


Use this one, in the next line

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"
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"
That's because you have not provided a value for the false outcome

IF(condition, true, false).



Will will give you a null instead of the FALSE.

My System SpecsSystem Spec

 Excel Formula

Thread Tools

Similar help and support threads for2: Excel Formula
Thread Forum
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 10:39 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