Re: If statement with date
- From: Dave Peterson <ec35720@xxxxxxxxxxxxxxxxx>
- Date: Thu, 19 May 2005 19:08:54 -0500
Excel sees 1/1/05 as a couple of divisions. 1 divided by 1 divided by 5.
I like this style to use with dates:
=IF(B1>DATE(2005,1,1),(D1*0.03)+A1,A1)
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(B1>1/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?
--
Dave Peterson
.
- References:
- If statement with date
- From: Tanya
- If statement with date
- Prev by Date: Re: Is there any way to get rid of a link in a spreadsheet?
- Next by Date: Re: Unable to record macro
- Previous by thread: RE: If statement with date
- Next by thread: Re: If statement with date
- Index(es):
Relevant Pages
|
