Software

Ask something
Discussion Locked

Develope progressive formulas Excel 02

0 helpful
5 replies

by hmfl33498

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I need a formulas in Excel 2002 that will give me from 1%-20% of a number. For example using the number $589.37 equals 1%. How would I show the other 19 percentages with out doing them individually.Thank you.

5 replies

by dklippert

There is a little talked about analysis tool in Excel called a Data table.
In the Help file look for Table and then choose: "Ways to forcast values with What-if analysis (Data tables)."
You could also create a row of interest rates (C1:V1). in a seperate cell (A1)enter the Present Value.
Under 1% enter the formula =$A$1*C1
Fill the formula under the rest of the numbers the Absolute Value $A$1 will remain the same and the formula will adjust for the other numbers.

Under the

by hmfl33498

Sorry new user, need more help. Show exactly how to set up the answer . If 1% is $589.37 how would I set up a formulas that would show from 2% to 20%. Thank you.

by hmfl33498

Fantastic answer. Even went to the trouble of developing a work sheet . This made it perfectly clear. Cannot thank you enough.

This discussion is closed to new replies.