PDA

View Full Version : % formula



darkrider
03-02-2007, 04:51 PM
does anyone know what formula i have to use to workout a percentage

TrippyTom
03-02-2007, 04:54 PM
If you mean number format, it would be either:
0% or 0\% (depending if you want literal or not)

Bob Phillips
03-02-2007, 05:21 PM
The number divided by 100

or one cell divided by another

or ... more details

johnske
03-02-2007, 07:38 PM
A/B*100 or, A/B and format the cell as percentage

Cyberdude
03-03-2007, 02:25 PM
I usually use A/B-1, then format it as a %.
Also you can use the Text function to format it for you:

=Text(A/B-1,"0.0%")

Sid