Use B1<1/1/05 and it will work
Pat
"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?
|