How to simplify an IF(OR function?

Originally Posted by Richard Buttrey

Hi,

One way

=I8-H8-G24*IF(ISERROR(MATCH("comprehension",P3:P18))=TRUE,2,4)

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