Excel – Run formula only If cell contains a value

microsoft excel

I'm using Microsoft Office 365. I'd like to do something like


but sometimes K23 doesn't have a value. So I'm thinking I need to say only do +K23 if it contains a value.

How would I do that?

Best Answer

Try using


Unless sometimes G23 is blank or zero, replace /G23 with /if(G23<>"",G23,1)

Related Question