How do I create this conditional formula

Dlene03 - Oct 9, 2017 at 04:19 PM - Latest reply: TrowaD 2367 Posts Sunday September 12, 2010Registration dateModeratorStatus June 19, 2018 Last seen
- Oct 10, 2017 at 11:31 AM
How do I create this formula?
If A2, B2, and C2 has a combination of H, H, HP (it doesn't matter what order it is in), returns a score of 98 in cell D2.

H= Honors
HP = High Pass
See more 

Your reply

2 replies

ac3mark 9571 Posts Monday June 3, 2013Registration dateModeratorStatus June 19, 2018 Last seen - Oct 9, 2017 at 04:47 PM
0
Thank you
You can nest IF OR & AND. take a look at the example, and have fun!

=IF(AND(A3>B2,A3<C2),TRUE,FALSE)

You can read more here:
https://support.office.com/en-us/article/Using-IF-with-AND-OR-and-NOT-functions-d895f58c-b36c-419e-b1f2-5c193a236d97

Once again, have fun!
Respond to ac3mark
TrowaD 2367 Posts Sunday September 12, 2010Registration dateModeratorStatus June 19, 2018 Last seen - Oct 10, 2017 at 11:31 AM
0
Thank you
Hi Dlene,

Give the following formula a try:
=IF(IF(A2="H",1,IF(A2="HP",3,0))+IF(B2="H",1,IF(B2="HP",3,0))+IF(C2="H",1,IF(C2="HP",3,0))=5,98,"")

Best regards,
Trowa
Respond to TrowaD