On Thu, 19 May 2005 16:22:03 -0700, "Tanya"
wrote:

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?

for 1/1/05 to be interpreted as a date, it must either be enclosed in quote
marks or the result of a function (or cell reference).

=If(B1"1/1/05",(D1*.03)+A1,A1)

=If(B1DATE(2005,1,1),(D1*.03)+A1,A1)

=If(B1$Z$2,(D1*.03)+A1,A1) 'where Z2 contains the date 1/1/05


--ron