Results 1 to 3 of 3

Thread: Small formula needed

  1. #1

    Small formula needed

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

    Thanks & Regards,

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Excel Version
    Put in G2:


    and copied down

  3. #3
    You could just change the format of the cell so that the actual number remains, it just shows as >100%, by using a custom number format of


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts