Remember Me?

#1
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 2
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

#2
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 2,069
Formulation question

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

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

#3
Posted to microsoft.public.excel.charting
 external usenet poster Posts: 6,582
Formulation question

A more flexible solution would be to create a lookup table (D5:E7 in my
example):

0 0.45
1200 0.47
2000 0.5

then with the value to convert in H5, put this formula in I5:

=H5*(VLOOKUP(H5,\$D\$5:\$E\$7,2))

This gives you a = relationship, not the in John's formula. If you need
, you can subtract 0.01 from the values in D5:D7.

This formula is an improvement because the cutoff values and percentages are
contained in a single table. If you need to adjust them you only need to
change the table, not every formula that relies on the values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"john" wrote in message
...
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

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TJ Bartel New Users to Excel 1 March 5th 07 02:54 AM turrucan Excel Worksheet Functions 6 December 19th 06 11:48 AM OSCAR Excel Discussion (Misc queries) 3 December 31st 05 07:53 AM OSCAR Excel Discussion (Misc queries) 2 December 31st 05 06:06 AM [email protected] Excel Worksheet Functions 0 September 6th 05 09:36 PM

All times are GMT +1. The time now is 09:24 PM.