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.
 

Azumi

New member
Joined
Jan 2, 2014
Messages
30
Reaction score
0
Points
0
Location
Indonesia
Excel Version(s)
2010
Put in G2:

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

and copied down
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
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%
 
Top