Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Here are the requirements
I need one answer with different parameters within one formula If amount is less than or equal to 100 then answer will be Zero If amount is more than 100 but less than or equal to 150 then answer will be 8% of the amount exceeding 100 If amount is more than 150 but less than or equal to 300 then answer will be 25 + 12% of the amount exceeding 150 If amount is more than 300 but less than or equal to 400 then answer will be 50 + 20% of the amount exceeding 300 If amount is more than 400 but less than or equal to 700 then answer will be 75 + 25% of the amount exceeding 400 If amount is more than 700 then answer will be 100 + 35% of the amount exceeding 700 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Problem for Newbie - Please! | New Users to Excel | |||
Real Newbie newbie question | New Users to Excel | |||
formula series (newbie) | Excel Worksheet Functions | |||
Newbie problem need formula help | Excel Worksheet Functions | |||
Newbie needs help deciphering formula. | Excel Worksheet Functions |