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.
Bookmarks