Pecentage

[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.

 

[R.VENKATARAMAN]

=2b/1b and format it to percentage. mine is excel2000
is this what you mean
it come to 0.01%

 

[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

 

[hagadol]

Thanks for the quick responses ! It worked !

 

[Max]

Glad it worked !