Forum Discussion
Glow26
Sep 12, 2020Copper Contributor
Representing percentages
I want a excel formula that will represent big percentages as <100% or >100%
SergeiBaklan
Sep 13, 2020Diamond Contributor
That's not clear what you are looking for. Why 100%, not 50% or 1000% ?
Glow26
Sep 13, 2020Copper Contributor
for reporting purposes I rather say that for example this years expenses is higher than last year by >100% than 879% SergeiBaklan
I know I can write a if formula, I just can remember it
Thank you
- Riny_van_EekelenSep 14, 2020Platinum Contributor
- SergeiBaklanSep 14, 2020Diamond Contributor