| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Commission - IF formulas
You're welcome, have a great day!
VT - Maryland wrote: GREAT, it worked!!! "Bob I" wrote: Try this =IF((C224499)+(C22<2600),0,C22*0.25) VT - Maryland wrote: This is what I want: <2600 - should equal $0.00 2600 <4499 - should equal 25% of the amount over $2,600 and less than the amount $4,499 and =4500 - should equal $0.00 If Cell C22 is at least $2,600 and not larger than $4,499 returns a commission of 25% of the amount. If cell c22 is$2,499 returns $0.00. If cell c22 is $4,500 returns a zero $0.00 "Bob I" wrote: there are three outcomes, what do you want for =<2600 2600 <4499 and =4500 currently nothing is set for 4500 only greater than which doesn't match your stated desire. VT - Maryland wrote: I need formula for commission of 25% if cell c22 is greater than $2,600. and less than $4,499. I keep trying =IF(C224500,"0",IF(C22<2600,"c22*25%")) with a value in cell c22 of $4,500, but I get the result of FALSE instead of zero. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sliding scale commission percentages formulas | Excel Worksheet Functions | |||
| Commission Spreadsheet Help | Excel Discussion (Misc queries) | |||
| Commission Formula | Excel Discussion (Misc queries) | |||
| Commission formula | Excel Discussion (Misc queries) | |||
| Commission formula | Excel Worksheet Functions | |||
Hybrid Mode
