Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,546
    Thanks
    138
    Thanked 11 Times in 11 Posts

    If function help

    I have percentages in Col's U & T

    I would like to set up a logical formula that the % in Col T >= 75, "PD", "P". However, if the % in CCol U <40, "Fail"

    Your assistance in this regard is most appreciated

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,570
    Thanks
    44
    Thanked 73 Times in 69 Posts
    Do you want the result in the cell to be "PD" if the value in the T column is >= 75 and if not, a "P"?

    =IF(T1>=75,"PD","P") and fill this down.

    Or do you want to set the cell to "Fail" if U is <40, otherwise do the test on the T column?

    =IF(U1<40,"Fail",IF(T1>=75,"PD","P")) and fill down.

    Hope this helps.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,546
    Thanks
    138
    Thanked 11 Times in 11 Posts
    Thanks for the help, much appreciated. The formula =IF(U1<40,"Fail",IF(T1>=75,"PD","P")), does the trick

Posting Permissions

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