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?