Hello,
This is my first time posting. I am working with the following function:
It does what I need it to do, but I would like for the response to be "Yes" or "No" rather than TRUE and FALSE. I have not been able to figure out how to fix this myself. Does anyone have any ideas that they can give me?
=IF(AND(H2>=80),OR(AVERAGE(H2,J2)>=85, AVERAGE(H2,L2)>=85,))
Thank you.
Maybe this regular formula:
Formula:
=IF(H2>=80,IF(OR(AVERAGE(H2,J2)>=85, AVERAGE(H2,L2)>=85),"Yes","No"),"No")
Does that help?
Here's what your formula does,
IF H2 >= 80, then if AVERAGE H2 and J2 >=85 or Average of H2 and L2 >=85 respond "True", otherwise, "False"
Some other issues (besides the fact it's probably not doing what you want it to do)
you have AND(H2>=80), there's only 1 argument, you don't need AND
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you Ron and ChemistB. You both cleared this up for me. I felt that I was overthinking this and making it more difficult than it needed to be.
You solved my problem!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks