calculating percentages

[imported_unknown]

What is the formula to calculate percentage of one cell to another?

 

[Yogi Anand]

Hi CarlaC:

Welcome to the Board!

If A1 is 100, and B1 is 10, then B1 is 10% of A1 -- and you will get that by

=B1/A1*100

Is that what you are looking for?

Regards!

Yogi

 

[flexinau]

Formula is "one cell" divided by "another cell".
Format the result by Format|cells|Percentage.

 

[Aladin Akyurek]

On 2002-10-06 23:27, CarlaC wrote:
What is the formula to calculate percentage of one cell to another?

=A1/B1

where A1< B1 and B1<> 0.

Stated otherwise:

=MIN(A1:B1)/MAX(A1:B1)
This message was edited by Aladin Akyurek on 2002-10-07 02:40