How to simplify an IF(OR function?

I have the following function and I'm wondering if there is a way to simplify it all so it's not so tedious to enter into multiple cells. Essentially, is there a way to search multiple cells for a value instead of doing a huge or function. The one I am currently using that works fine but is long is this:

=I8-H8-G24*(IF(OR($P$3="Comprehension",$P$4="Comprehension",$P$5="Comprehension",$P$6="Comprehension",$P$7="Comprehension",$P$8="Comprehension",$P$9="Comprehension",$P$10="Comprehension",$P$11="Comprehension",$P$12="Comprehension",$P$13="Comprehension",$P$14="Comprehension",$P$15="Comprehension",$P$16="Comprehension",$P$17="Comprehension"),4,2))

Is there a way to simplify that? Thanks for the help.

Originally Posted by daddylonglegs

...or try...

=I8-H8-G24*IF(COUNTIF($P$3:$P$17,"Comprehension"),4,2)

This seemed to work well. what does the CTRL+SHIFT+ENTER do though? Evaluate it as an array?

Originally Posted by Richard Buttrey

Hi,

One way

Please Login or Register  to view this content.

HTH

This ended up working perfectly for me and I was able to modify it for many other uses in my workbook. Thanks for this, the other array function given wouldn't work for me because I was using lots of merged cells