M
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?
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?