What formula can I use to return "Error" if any of the children are blank?
I'm trying to write a formula where if any of the children of a cell are blank, the value returned is "Error". I've done some searching and figured how to return this value if all the children cells are blank, but I want the "Error" value to be returned if even 1 cell is blank.
Thanks in advance for your help!
Help Article Resources
Check out the Formula Handbook template!