Question
June 25, 2009 at 10:06 AM
heyrobi

Help with “IF” spreadsheet formula

by heyrobi . Updated 17 years, 2 months ago

I am making a spreadsheet to help calculate commissions. The percentage I need depends on a certain amount of volume entered. So I want to be able to put in A1 the sales volume and then in A2 if the number in A1 is between 0 and 7500 it will equal 15% 7500 to 15000 it will equal 20% and 15000 to 50000 it will equal 25% how would I write that formula?

TIA

HeyRobi

This discussion is locked

All Comments