If your value is in cell A1 then try
=IF(A12000,A1*50%,IF(A11200,A1*47%,A1*45%))
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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