Results 1 to 2 of 2

Thread: help me in writing a formula

  1. #1

    help me in writing a formula



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

    I use a formula to mark "pass" or "fail", which is =IF(C2>=25, "Pass", "Fail")

    now the question is, when I use "A" (absent) in cell the result is "Pass", please tell me how I can write formula to get the "Fail" in result column after writing "A" in Marks column
    i have also attached excel file for your kind observation
    thanks
    Attached Files Attached Files

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    357
    Articles
    0
    Here's two formulas that will do it:
    =IF(OR(C2<26,C2="a"),"Fail","Pass")
    ==IF(C2="a","Fail",IF(C2>=25, "Pass", "Fail"))

Posting Permissions

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