Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula with a cell that is a formula
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula with a cell that is a formula
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Formula with a cell that is a formula
On Wed, 23 Jan 2008 10:14:04 -0800, 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? The IF function IS reading the output value of A1. It is NOT reading the formula. The problem is that you don't understand what the NOW() function is doing. From HELP for NOW: Returns the serial number of the current date and time. It would be fortuitous if a manually entered date in A2 would match the date + time in A1. Some possible solutions: 1. In A1, use the TODAY function rather than the NOW function. 2. For your formula, use INT(A1) = A2 --ron |
#4
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 |