Rookie Alert-

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kss - 21 Jul 2006 16:03 GMT

Need simple formula for finding 30% of a number

Reply to this Message

Max - 21 Jul 2006 18:56 GMT

> Need simple formula for finding 30% of a number

Assume your numbers are going down in A2, A3, A4, etc
Enter the desired percent in cell B1, ie key-into B1: 30% (including the
"%")
Then put in B2: = A2*B$1
Press ENTER
Then drag the fill handle* of B2 down as far as required,
to compute accordingly for the other values in A3, A4, etc
*that's the solid square at the bottom right corner of B2

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Wiley - 21 Jul 2006 20:26 GMT

Going off of Max's example, you could also type the formula in B2 as "=B1*.3"
and drag down.

> > Need simple formula for finding 30% of a number
>
[quoted text clipped - 6 lines]
> to compute accordingly for the other values in A3, A4, etc
> *that's the solid square at the bottom right corner of B2

Reply to this Message

Max - 22 Jul 2006 09:15 GMT

> .. in B2 as "=B1*.3"

Yes, of course, but that would simply be hardcoding it. Usually, it's better
to illustrate by having the formula pointing to a cell (eg B1 in the earlier
example) so that we can easily adjust/change the percentage in that one cell
to another value (if we need to), without having to edit and re-fill the
formulas down col B.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message