|
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. |
If formula---adding another condition
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. |
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. |
If formula---adding another condition
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! "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. |
If formula---adding another condition
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 wrote: 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! "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.- Hide quoted text - - Show quoted text - |
If formula---adding another condition
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! "Pete_UK" wrote: 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 wrote: 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! "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.- Hide quoted text - - Show quoted text - |
If formula---adding another condition
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(C 2="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 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. It should = 25 for the first non-consecutive occurance and 50 for every consecutive occurance following. Thanks to all! "Pete_UK" wrote: I'mnotBob, 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 wrote: 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! "BobPhillips" 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 arenotmet 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.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 07:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com