The problem would be the way you are entering the date in the If statement.

Try to type the date in a cell, and then compare among two cells.

=If(B1$F$1,(D1*.03)+A1,A1)

Where the cell F1 contains the date (1/1/05)

The thing is that Excel interprets 1/1/05 as a series of divisions, which
leads to the result of 1/5 (0.2)

Hope that helps. Please rate this post.

"Tanya" wrote:

I'm trying to return new salary information based on a hire date. The
criteria is if you were hired on or before Jan. 1, 2005, you get 3% of the
mid-point of your current salary range. I have the spreadsheet set up as
follows:

A1 B1 C1 D1 E1
Current sal hire date PG mid-point new salary
40,950.00 12/15/03 15 52,460.00 ????

I was using the formula in E1:
=If(B11/1/05,(D1*.03)+A1,A1)

But when I entered a hire date that was after 1/1/05, it was still adding
the 3%. What am I doing wrong?