formulation question
 

I am trying to create a sliding scale for a payroll functionand would like
to create three different percent calculations on one cell based on the
amount. for instance if the cell value is 0-1200.00*45% if the value is over
1200.00*47% if value is over 2000.00 *50%
I have tried to do this for hours but having NO luck

thanks for any HELP

formulation question
 

One way:

=A1*(45%+2%*(A11200)+3%*(A12000))

In article ,
"TJ Bartel" wrote:

I am trying to create a sliding scale for a payroll functionand would like
to create three different percent calculations on one cell based on the
amount. for instance if the cell value is 0-1200.00*45% if the value is over
1200.00*47% if value is over 2000.00 *50%
I have tried to do this for hours but having NO luck

thanks for any HELP