Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with date for an answer
Can someone give me an example of a formula that will look at the contents of
one cell, and if that cell is = 0 then another cell will display todays date and time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with date for an answer
another way
=IF(AND(NOT(ISTEXT(E2)),E2=0),NOW(),"?") "joe" wrote: Can someone give me an example of a formula that will look at the contents of one cell, and if that cell is = 0 then another cell will display todays date and time. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with date for an answer
Joe,
The formula can't put anything into another cell, but you could have a formula in the cell that's to show the date if another cell is = 0. If A2 is the cell to be examined for =0, put this in the cell that's to display the date. =IF(A2=0,NOW(),"") This will display the current date-- it doesn't freeze the date. Today it will display today's date. Tomorrow, tomorrow's date. -- Earl Kiosterud www.smokeylake.com Note: Top-posting has been the norm here. Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "joe" wrote in message ... Can someone give me an example of a formula that will look at the contents of one cell, and if that cell is = 0 then another cell will display todays date and time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula with date answer | Excel Discussion (Misc queries) | |||
using lookup to return more than one answer in date format | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
i want to add a number to a date and get the date as an answer eg. | Excel Worksheet Functions | |||
If and (and) formula to allow a zero answer | Excel Worksheet Functions |