Please help me with the below formula;
Say if
A1=Cat and B1=Rat and C2>=80
Then D2 should result the character "Y"
if any of the values are different then D2 should result the character "N"
I tried with the below formula in D2 but it results as "False" when I change the value in B1 as Dog rather than resulting a "N"
=IF(A2="Cat",IF(B2="Rat",IF(C2>=80,"Y","N")))
Thanks in advance!
hi ssanjju, you can try this instead:
=IF(AND(A2="Cat",B2="Rat",C2>=80),"Y","N")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi ssanjju,
Use this formula in cell D2 within the relevant sheet:
=IF(AND(A1="Cat",B1="Rat",C2>=80),"Y","N")
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
=IF(A1="Cat",IF(B1="Rat",IF(C2>=80,"Y","N")))
You probably miss place you cell datas.
But I wonder how would you use this formula.. XD
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks