# Software

## General discussion

Locked

### Develope progressive formulas Excel 02

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

Thread display: Collapse - | Expand +

Collapse -

### Develope progressive formulas Excel 02

by 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 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 In reply to Develope progressive form ...

I have sent you a sample.

Collapse -

### Develope progressive formulas Excel 02

by 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 In reply to Develope progressive form ...

This question was closed by the author

## Related Discussions

• 4

#### Quickbooks 2017 crash com Error

AcerNancy98 ·

• 1

#### php related validation issue

himanitechbag ·

• 2

WernDB ·

• 1

#### Which is Best Software for Gym Fitness Club Business Management?

nomedamilton ·

• 11

#### which can be the best and good cloud base software ?

tofiqueshaikh25 ·