Small formula needed

[aakhan2011]

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 .

http://speedy.sh/XSdGT/Small-formula-change-needed.xlsx


Thanks & Regards,
A.A.K.

 

[iyyi]

Try: =MIN(your formula,100%)

 

[mfexcel]

Try:
=if(Your Formula>1,">100%",Your Formula)

Or if you wish to keep the calculated result, you may apply a custom format: [>1]">100%"

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 .

Small formula change needed.xlsx - Speedy Share - upload your files here


Thanks & Regards,
A.A.K.