If formula---adding another condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hmsawyer - 28 Mar 2008 17:57 GMT

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.

Reply to this Message

Bob Phillips - 28 Mar 2008 18:16 GMT

Dont use a text $25.00, just use a number and format as $ currency

In C3

=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+(B3=25)*25))

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I have this formula already set up:
>
[quoted text clipped - 14 lines]
>
> Thank you again for your help. I really appreciate it.

Reply to this Message

hmsawyer - 28 Mar 2008 18:45 GMT

That is only returning 25 in C3 (and B3 does = 25).

Thanks.

> Dont use a text $25.00, just use a number and format as $ currency
>
[quoted text clipped - 22 lines]
> >
> > Thank you again for your help. I really appreciate it.

Reply to this Message

hmsawyer - 28 Mar 2008 19:06 GMT

Bob,

I have that working now, how do I add that it return $50 if the preceding
cell = $25 OR $50. As it is now, it goes back to $25 if the preseding = $50.

Thank you!

> Dont use a text $25.00, just use a number and format as $ currency
>
[quoted text clipped - 22 lines]
> >
> > Thank you again for your help. I really appreciate it.

Reply to this Message

Pete_UK - 28 Mar 2008 20:04 GMT

I'm not Bob, but you can change the very end of the formula to this:

,25+(B3>=25)*25))

Hope this helps.

Pete

On Mar 28, 6:06 pm, hmsawyer <hmsaw...@discussions.microsoft.com>
wrote:

> Bob,
>
[quoted text clipped - 38 lines]
>
> - Show quoted text -

Reply to this Message

hmsawyer - 28 Mar 2008 20:32 GMT

I tried that, but it returns 50 after a No. It should be 25 after a No and
50 after a 25 and/or after a 50.

It should = 25 for the first non-consecutive occurance and 50 for every
consecutive occurance following.

Thanks to all!

> I'm not Bob, but you can change the very end of the formula to this:
>
[quoted text clipped - 48 lines]
> >
> > - Show quoted text -

Reply to this Message

Pete_UK - 29 Mar 2008 15:50 GMT

Okay, try it this way in C3:

=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",IF(C2="No",
25,MIN(SUM(C2,25),50))))

and copy down. Not sure what could be in C2, hence the SUM.

Hope this helps.

Pete

On Mar 28, 7:32 pm, hmsawyer <hmsaw...@discussions.microsoft.com>
wrote:

> I tried that, but it returns 50 after a No. It should be 25 after a No and
> 50 after a 25 and/or after a 50.
[quoted text clipped - 59 lines]
>
> - Show quoted text -

Reply to this Message