M
MP
I am trying to put a date in an IF statement, so that the
true equals a number and the false goes to another cell.
The formula I have written returns the correct false
response, but not the correct true response. Here is the
formula
IF(B7="March 31, 2004",90,B129). It also doesn't work if
I put the date as 3/31/04 or 3/31/2004.
Thank you for any assistance
true equals a number and the false goes to another cell.
The formula I have written returns the correct false
response, but not the correct true response. Here is the
formula
IF(B7="March 31, 2004",90,B129). It also doesn't work if
I put the date as 3/31/04 or 3/31/2004.
Thank you for any assistance