An Error in Excel called “#REF!” (with REF standing for reference) happens when a formula refers to an invalid cell. This usually occurs when cells referenced by formulas are deleted ...
Read more
This post first appeared on Excel If Statement Multiple Conditions Range, please read the originial post: here