Why is my IF statement not working

[DorianC]

Cell G5 = Day()-F5
Cell G5 is titled "Days left"
F5 is titled "expires date" -formated 1/1/01
So the outcome to G5 is a integer in days

When I put
=IF(G5>90,"NO","YES")
into H5 which is titled "Send email"
H5 column does not change it just displays my equation.

This is becoming really fursterating!

I opened a new excel and it worked that is why I am not sure why it is not working for this one!

 

[EOAEvan]

im not exactly sure why this happens but if you change the format of the cell you entered your formula into to "general" and re-enter the formual it will work. (you can also just click on the = sign on the formula bar then click the check mark or hit enter. I believe if you look at the current format it will be text

 

[DorianC]

Thanks a lot it works know!
It was that I had it formatted as text instead of general.

 

[lenze]

First, DAY() is not an Excel function! (At least in USA version)You need to use TODAY().
Make sure G5 is formatted as General
If, however, which I assume, your expires date is in the future, I believe your formula should be F5-TODAY()

Your IF formula is correct
HTH
lenze

 

[Norie]

First, DAY() is not an Excel function!

Have they removed it in 2007?.

 

[lenze]

Don't know Norie. Never used 2007

lenze

 

[Norie]

lenze

I'm just joshing.

Did you forget about this?

DAY

See Also
Returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.
For more information about how Microsoft Excel uses serial numbers for dates, see the Remarks section.

 

[lenze]

Yes, Norie, I had a senior moment, The point was, it was the wrong function for what the OP said they were doing and requires an argument.

lenze

 

[Jym396]

I was having the problem and struggled and got a little frustrated. Excel is never wrong!

What I did is just re-enter the number in the reference cell and...BANG!!!

Hey...it worked for me..maybe it could help you too.