Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Logical Function
I want just one formula to calculate employee bonuses given the following
three scenarios: 1) If Gross Profit is under 250,000, no bonus 2) If GP is between 250,000 and 750,000, bonus is 3% of GP minus 250,000 3) If GP is 750,000 or more, bonus is 3% of total GP In cell A1, I will be inputing the employees GP. In cell A2, I want the bonus amount to be calculated. So far, I have the following formulas which calculate scenarios 1/2 and 3 respectively, but I don't know how to combine them: =IF(D29<250000,0,0.03*(D29-250000)) =IF(D29=750000,0.03*D29) Thanks for your help!! |
#2
|
|||
|
|||
=IF(D29<250000,0,IF(D29<750000,0.03*(D29-250000),0.03*D29))
Vaya con Dios, Chuck, CABGx3 "vnsrod2000" wrote in message ... I want just one formula to calculate employee bonuses given the following three scenarios: 1) If Gross Profit is under 250,000, no bonus 2) If GP is between 250,000 and 750,000, bonus is 3% of GP minus 250,000 3) If GP is 750,000 or more, bonus is 3% of total GP In cell A1, I will be inputing the employees GP. In cell A2, I want the bonus amount to be calculated. So far, I have the following formulas which calculate scenarios 1/2 and 3 respectively, but I don't know how to combine them: =IF(D29<250000,0,0.03*(D29-250000)) =IF(D29=750000,0.03*D29) Thanks for your help!! |
#3
|
|||
|
|||
Works perfectly, thanks!
"CLR" wrote: =IF(D29<250000,0,IF(D29<750000,0.03*(D29-250000),0.03*D29)) Vaya con Dios, Chuck, CABGx3 "vnsrod2000" wrote in message ... I want just one formula to calculate employee bonuses given the following three scenarios: 1) If Gross Profit is under 250,000, no bonus 2) If GP is between 250,000 and 750,000, bonus is 3% of GP minus 250,000 3) If GP is 750,000 or more, bonus is 3% of total GP In cell A1, I will be inputing the employees GP. In cell A2, I want the bonus amount to be calculated. So far, I have the following formulas which calculate scenarios 1/2 and 3 respectively, but I don't know how to combine them: =IF(D29<250000,0,0.03*(D29-250000)) =IF(D29=750000,0.03*D29) Thanks for your help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |