Representing percentages

%3CLINGO-SUB%20id%3D%22lingo-sub-1661163%22%20slang%3D%22en-US%22%3ERepresenting%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661163%22%20slang%3D%22en-US%22%3EI%20want%20a%20excel%20formula%20that%20will%20represent%20big%20percentages%20as%20%26lt%3B100%25%20or%20%26gt%3B100%25%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661163%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661643%22%20slang%3D%22en-US%22%3ERe%3A%20Representing%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791624%22%20target%3D%22_blank%22%3E%40Glow26%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20clear%20what%20you%20are%20looking%20for.%20Why%20100%25%2C%20not%2050%25%20or%201000%25%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1662650%22%20slang%3D%22en-US%22%3ERe%3A%20Representing%20percentages%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1662650%22%20slang%3D%22en-US%22%3E%3CP%3Efor%20reporting%20purposes%20I%20rather%20say%20that%20for%20example%20this%20years%20expenses%20is%20higher%20than%20last%20year%20by%20%26gt%3B100%25%20than%20879%25%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20I%20can%20write%20a%20if%20formula%2C%20I%20just%20can%20remember%20it%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
I want a excel formula that will represent big percentages as <100% or >100%
4 Replies
Highlighted

@Glow26 

That's not clear what you are looking for. Why 100%, not 50% or 1000% ?

Highlighted

for reporting purposes I rather say that for example this years expenses is higher than last year by >100% than 879% @Sergei Baklan 

 

I know I can write a if formula, I just can remember it 

 

Thank you

Highlighted

@Glow26 

Perhaps you mean

=IF(A1>1,8.79,A1)
Highlighted

@Glow26 or perhaps:

=IF(A1>1,">100%",A1)