Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Rookie Alert-
Need simple formula for finding 30% of a number
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Rookie Alert-
"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 --- |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Rookie Alert-
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 --- |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
Rookie Alert-
.. 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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a pop-up alert when a condition is reached in excel | Excel Discussion (Misc queries) | |||
Email alert to call or view a line in a spreadsheet | Excel Worksheet Functions | |||
How to avoid this Alert screen | Excel Discussion (Misc queries) | |||
Can I set an audio alert that triggers as Excel cell value chgs? | Excel Discussion (Misc queries) | |||
Diable Chart Information Alert | Charts and Charting in Excel |