Reducing a Formula

[josephkentcraig]

Is there anyway to reduce this formula into a simpler form?

=IF(AND(ISBLANK(C11),ISBLANK(E11)),"",G10+SUM(C11,E11))

For instance, any way to combine =IF(AND(ISBLANK(C11),ISBLANK(E11)) this part of it?

 

[sheetspread]

len(c11&e11)=0

?

or COUNTA(C11,E11)=0

 

[josephkentcraig]

hmmm... neither of those worked for me.

 

[sheetspread]

=IF(COUNTA(C11,E11)=0,"",G10+SUM(C11,E11))

worked when I tried it

 

[josephkentcraig]

Okay thanks!! I put =IF(COUNTA(C11,E11)=0),"",G10+SUM(C11,E11))
Had an extra parentheses in there!

 

[Peter_SSs]

You were looking for shorter ..
=IF(C11&E11="","",SUM(G10,C11,E11))

 

[sheetspread]

You were looking for shorter ..
=IF(C11&E11="","",SUM(G10,C11,E11))

That is better if you're searching for both "" and true blanks