View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
marti marti is offline
external usenet poster
 
Posts: 15
Default If Then Calculations

Help!
I'm a small business owner trying to design a commission spreadsheet based
on commissions that depend on profits.

For Instance:
Profits = 1000 - 5000, Commission = 2%
Profits = 5001 - 10000, Commission = 4%
Profits = 15001 - 20000, Commission = 5%

I can figure out how to make words fill the cell based on the number input
but I cant get it to perform a calculation based on the number input.

Help!

Marti