I'm using Microsoft Office 365. I'd like to do something like
=(SUM(J4:J20)+K23)/G23
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?
Try using
=SUM(J4:J20,IF(K23<>"",K23))/G23
Unless sometimes G23
is blank or zero, replace /G23
with /if(G23<>"",G23,1)
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments