Forum Discussion

Glow26's avatar
Glow26
Copper Contributor
Sep 12, 2020

Representing percentages

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

4 Replies

    • Glow26's avatar
      Glow26
      Copper 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

Resources