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
yimveasna

Windows 7 64 bit
 
 
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 System SpecsSystem Spec
.
11 Mar 2014   #2
archer

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
yimveasna

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
TanyaC

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
Thread Forum
Excel 2016: Displaying formulas in the formula bar
I am using Win 7 Pro 7601 Multiprocessor Free SP1, 64-bit. Intel Core i7-4770, 16GB installed memory. Excel 2016. I have a spreadsheet with formulas, none of which display in the formula bar. All my other spreadsheets display their formulas in the bar. I have tried the following to display the...
Microsoft Office
excel formula not shown if the cells are empty
i have excel file, with the following formulas Cell G2 formula =SUM(D2:F2) Cell G3 formula =SUM(G2, D3:F3) Cell G4 formula =SUM(G3, D4:F4) Cell G5 formula =SUM(G4, D5:F5) i want the result of G5 (and the rest of G cells) cells to be invisible unless there is some value in D5 to F5 cells ...
Microsoft Office
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
Excel 2003 sum formula problem
I have been entering currency data in Column B in Euros to an EXCEL 2003 s/s and the formula used has added these totals entered in that Column correctly until I reached a total sum of 74364.70 Euros ,this being the sum of entries in Rows B6 to B82 . This was reached with the formula showing as...
Microsoft Office
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work. I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan...
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 07:28.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App