View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sconstance sconstance is offline
external usenet poster
 
Posts: 3
Default 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?