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,
    A.A.K.

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Location
    Indonesia
    Posts
    29
    Articles
    0
    Excel Version
    2010
    Put in G2:

    =IF(D2/C2>1,">100%",D2/C2)

    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

    [>1]">100%";0.00%

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
  •