IF formula--adding another condition

I have this formula already set up:

=IF(TODAY()<DATE(2008,3,1),"",IF(COUNTIF('Employee
Attendance'!12:12,">="&DATE(2008,6,1))-COUNTIF('Employee
Attendance'!12:12,">="&DATE(2008,7,1))>0,"No","$25.00"))

It is in every cell on the worksheet in Columns B-IV.

I need to amend it so that if the cell preceding it is already =$25.00, it
will make the next one =$50.00 if the same conditions are met.

So if B3=$25.00 and the if conditions are met for C3 it will return $50.00.
If the conditions are not met for C3, but are for D4, it will return $25.00.
Only when the conditions are met consecutively should it return $50.00.

Thank you again for your help. I really appreciate it.

Joseph
Fri Mar 28 09:44:00 PDT 2008



"hmsawyer" <hmsawyer@discussions.microsoft.com> wrote in message
news:DD401A82-DC15-4F4A-BD6B-68AD02B50AC9@microsoft.com...
> I have this formula already set up:
>
> =IF(TODAY()<DATE(2008,3,1),"",IF(COUNTIF('Employee
> Attendance'!12:12,">="&DATE(2008,6,1))-COUNTIF('Employee
> Attendance'!12:12,">="&DATE(2008,7,1))>0,"No","$25.00"))
>
> It is in every cell on the worksheet in Columns B-IV.
>
> I need to amend it so that if the cell preceding it is already =$25.00, it
> will make the next one =$50.00 if the same conditions are met.
>
> So if B3=$25.00 and the if conditions are met for C3 it will return
> $50.00.
> If the conditions are not met for C3, but are for D4, it will return
> $25.00.
> Only when the conditions are met consecutively should it return $50.00.
>
> Thank you again for your help. I really appreciate it.
>
>

Unless I miscounted you have 2 too many " ) " with out paired " ( "

eg. IF(TODAY()<DATE(2008,3,1)



--
Joseph Meehan

Dia 's Muire duit

hmsawyer
Fri Mar 28 09:56:02 PDT 2008

No, the formula is working, I just need to add the new condition.

I also meant to post this under Excel so I'll move it there. Sorry!

"hmsawyer" wrote:

> I have this formula already set up:
>
> =IF(TODAY()<DATE(2008,3,1),"",IF(COUNTIF('Employee
> Attendance'!12:12,">="&DATE(2008,6,1))-COUNTIF('Employee
> Attendance'!12:12,">="&DATE(2008,7,1))>0,"No","$25.00"))
>
> It is in every cell on the worksheet in Columns B-IV.
>
> I need to amend it so that if the cell preceding it is already =$25.00, it
> will make the next one =$50.00 if the same conditions are met.
>
> So if B3=$25.00 and the if conditions are met for C3 it will return $50.00.
> If the conditions are not met for C3, but are for D4, it will return $25.00.
> Only when the conditions are met consecutively should it return $50.00.
>
> Thank you again for your help. I really appreciate it.
>
>