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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.