Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with =IF formula
I need a formula to do this: if the sale is less than $100 the commission is
15% of the sale, if the sale is less then $200 the commission is 15% on the first hundred + 10% of the balance of the sale, and if the sale is over $200 the commission is 15% of the first $100 , 10% of the second $100 and 5% for anything over $200. I came up with =IF(D9<100,".15",IF(D9<200,".1","")) which does not come near to what I need. I need help, I am using Excel 2002. Harvey Mandel |