Forum Discussion
Solved
Simple formula not working
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: =IF(K16=0,"",(L1...
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?
=IF(K16=0,"",L16+N(M16)*1.5+N(N16)*2)
or
=IF(K16=0,"",SUMPRODUCT(L16:N16,{1,1.5,2}))
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?
=IF(K16=0,"",L16+N(M16)*1.5+N(N16)*2)
or
=IF(K16=0,"",SUMPRODUCT(L16:N16,{1,1.5,2}))
