Hi,
I want to do this in Excel.
Check this image.
\1
If the number is equal or above 39 in Columns M1 and M3
AND
number is equal or above 2 in Column B
I want to show text "Pass" in a blank column.
If not (that means if above values are less), it should show text "Fail".
Please help me with this.
Thanks
With "Name" in cell A2
IF(AND(B3>=39,D3>=39,F3>=2),"Pass","Fail")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Tried Special-K suggestion. Not working for me mate. I replaced relevant column values.
Thanks
What cell is "Name" in ?
BTW: "Mathamatics 32" should be "Mathematics 32"
and it looks like you have "Fass - 1" rather than "Pass - 1"
Name is in cell "C"
Thanks
Just adapt the formula:
=IF(AND(C3>=39,E3>=39,G3>=2),"Pass","Fail")
Last edited by AliGW; 07-31-2017 at 09:58 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I forgot to enter "=" at the beginning. Its working now. Thank you both for helping me.
Yes, that would help!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks