Excel

[mike]

I'm trying to get a spread sheet to do the following:

Enter $243,323 (for example)

Now i want the first $100,000 to be multiplied by 5% and
the next $100,000 to be multiplied by 6%, and the
remaining $43,323 to be multipled by 7%. However, i'm
trying to set it up so you only need to enter a value in
one cell ($243,323 entered in cell A1) to get it to do
all the calculations. Any ideas?

 

[Ray at]

You may want to try posting to an Excel group... And I also suggest
changing the subject line when you do. In an Excel group, it will be
obvious that your post will pertain to Excel. Try
m.p.excel.worksheet.functions

Ray at work