Small formula needed

aakhan2011

New member
Joined
Jan 16, 2014
Messages
17
Reaction score
0
Points
0
I am using a sheet in which the G column values are auto calulatable using formula field and gives the result in % .
I want to use a condition in the formula so that if result is > 100 % then it should print >100% instead of other values%.
Sample sheet attached which clearly tells how it looks before and after .

View attachment Small formula change needed.xlsx

Thanks & Regards,
A.A.K.
 
Put in G2:

=IF(D2/C2>1,">100%",D2/C2)

and copied down
 
You could just change the format of the cell so that the actual number remains, it just shows as >100%, by using a custom number format of

[>1]">100%";0.00%
 
Back
Top