General discussion

Locked

Develope progressive formulas Excel 02

By hmfl33498 ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Develope progressive formulas Excel 02

by DKlippert In reply to Develope progressive form ...

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

Collapse -

Develope progressive formulas Excel 02

by hmfl33498 In reply to Develope progressive form ...

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.

Collapse -

Develope progressive formulas Excel 02

by DKlippert In reply to Develope progressive form ...

I have sent you a sample.

Collapse -

Develope progressive formulas Excel 02

by hmfl33498 In reply to Develope progressive form ...

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

Collapse -

Develope progressive formulas Excel 02

by hmfl33498 In reply to Develope progressive form ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums