Representing percentages

Copper Contributor
I want a excel formula that will represent big percentages as <100% or >100%
4 Replies

@Glow26 

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

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

@Glow26 

Perhaps you mean

=IF(A1>1,8.79,A1)

@Glow26 or perhaps:

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