Going off of Max's example, you could also type the formula in B2 as "=B1*.3"
and drag down.
"Max" wrote:
"kss" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---