In cell A1, I want it to preferably populate with the contents of B2. However if B2 contains 0 or says #N/A N/A then I'd like it to populate with C2. If C2 ALSO contains 0 or says #N/A N/A then just populate with the 0.
At the moment, I can only get this to work if the cell says 0 or #VALUE!, but I need it to work for generally anything other than a number. This is my current formula:
=IF(ISERROR(B2),IF(ISERROR(C2),0,C2),IF(B2=0,IF(ISERROR(C2),0,C2),B2))
Does anyone have any suggestions? :/ Thanks!
Bookmarks