| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula with a cell that is a formula
Thanks that fixed it. Makes since.
"ShaneDevenshire" wrote: Hi, Try using =TODAY() instead of =NOW() NOW track the date and time even if only the date is exposed. -- Thanks, Shane Devenshire "sconstance" wrote: I'm trying to do a simple If function of If A1=A2 then return a 0 and if incorrect return a 1. However A1 is a NOW formula for the date and A2 is just the date manually entered. It keeps returning a 1 because of the formula in A1 even when the output of A1 matches A2. Is there a way to get the If function to read the output value of A1 instead of the formula inside of the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| "the formula in this cell differs from the formula in this area o. | Excel Worksheet Functions | |||
| Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Hybrid Mode
