Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
dim Commision, Amount
if Amount = 2 then Commision = 0.4 Amount = Amount - 2 end if if Amount = 2 then commision = Commision + 0.399 Amount = Amount -2 end if etc... Then put the values back into the sheet. Good luck, Jzz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sliding commission rates in excel | Excel Worksheet Functions | |||
Sliding 30 day calculation | Excel Discussion (Misc queries) | |||
Sliding scale commission percentages formulas | Excel Worksheet Functions | |||
Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) | |||
calculating commission on sliding scale | New Users to Excel |