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!

=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!

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

Give the following formula a try:

Best regards,

Trowa

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.