Pecentage

H

hagadol

How do I construct a formula to calculate the percentage amount of a
cell based on the percentage number in another cell.

For example:

1b = 10000

2b = 1

3b = The percentage amount of 1b when the percentage is whatever is
entered in 2b

Sorry, I have not used Excel for a while, know this is basic.
 
M

Max

If B2 is to house a number, e.g.: 1 (without the "%" sign entered)
then in B3: =B1*(B2/100)

If B2 is to house a percent figure, e.g.: 1% (with the "%" entered as
well)
put in B3: =B1*B2
 
Top