How do I create this conditional formula

Ask a question Dlene03 - Last answered on Oct 10, 2017 at 11:31 AM by TrowaD
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
plus moins
You can nest IF OR & AND. take a look at the example, and have fun!


You can read more here:

Once again, have fun!
Leave a comment
plus moins
Hi Dlene,

Give the following formula a try:

Best regards,
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!