Simple formula not working

Copper Contributor

I have a spreadsheet created by someone else that was full of formulas that didn't work and I am trying to correct them.  I have hit a simple formula that is making my head spin:




K16=8, L16=8, M16=0, N16=0


If M16 is blank, it doesn't work.  I get a #VALUE! error.  If there is a number in it, the formula returns the correct answer.


What am I missing?

2 Replies
best response confirmed by Sergei Baklan (MVP)


The formula should work if M16 is really blank. But if it contains a formula that returns an empty string "", you'll get an error.

Perhaps this?







@Hans Vogelaar 


Thank you!  The empty string was my problem!