Easy Question : Percentages

Posted by Joe on August 02, 2001 11:28 AM

I need a formula for percentages. Example - I want to know what percentage A6 is of A5 and I want that number to appear in A7.

Posted by Aladin Akyurek on August 02, 2001 11:52 AM

In A7 enter: =IF(A5,A6/A5,"")

Format A7 in % style if so desired.

Posted by Ian on August 02, 2001 12:01 PM

=A6/A5 in A7 format the cell to percentage (Right click Format_Cell or, cell selected Ctrl+1)
instead of Foramt_Cell you can use

=(A6/A5)*10

Ian