Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    formula to indicate percent higher (excel xp)

    In my column "E" i have values that i need to test against Column "A". If E5 is 10% higher than A5 i need to make it true. Then I need to take all the "trues" and sort them onto another sheet.

    I need some help with the IF statement in the formula and how to get all the trues onto another sheets.

    Thank ou very much

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: formula to indicate percent higher (excel xp)

    You don't need an IF

    In F5 enter something like:
    =E5 >1.1 * A5

    This will give a true or false.
    You can then autofilter on the "Trues" and then copy the filtered items to the other sheet

    Steve

Posting Permissions

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