If formula---adding another condition
That is only returning 25 in C3 (and B3 does = 25).
Thanks.
"Bob Phillips" wrote:
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))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"hmsawyer" wrote in message
...
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.
|