What do you get with the formula =C1?
Another thing to check if you are not getting the expected result is Tools/
Options/ Calculation, & make sure is says Automatic, not Manual.
--
David Biddulph

"wheefus" wrote in message
...
hi
i have a problem with using the if statement. i am updating a calculator
where a new value for the 2008 year.

here is the old if statement:
=IF(C1<=2006,16.8,22)*N1 giving a result for any date of 2006 or
before
of 16.8 and 22 for 2007. N1 HAS A VALUE IN THE
CELL
I taught that this was the updated calculator as 2008 has value of 24 to
return

=IF(C1<=2006,16.8,IF(C1=2007,22,IF(C1=2008,24)))* N1
I PUT THIS IN BUT THE RESULT RETURNED FOR 2008 STAYED AT 22

ANY IDEAS ??

p.s. C1 HAS CODE IN THE VISUAL BASIC EDITOR DOES THIS HAVE TO BE CHANGED
TO
INCORPOATE THE 2008 VALUE?