IF SUM blank cell returns as blank cell & 0 values returns 0

[chaiyya345]

Hi folks,

How to get the blank cell returns as blank cell & 0 values returns 0?

Blank cell:
=IF(SUM(C9:E9)>=1, SUM(C9:E9),"")

Zero:
=IF(SUM(C10:E10)>=1, SUM(C10:E10),)

I have to choose either one from the above, anyway to get both to works or with NESTED IF?

Thank-You very much

[Pete_UK]

Use this in F9:

=IF(C9&D9&E9="","",SUM(C9:E9))

then copy down.

Hope this helps.

Pete

[chaiyya345]

Use this in F9:

=IF(C9&D9&E9="","",SUM(C9:E9))

then copy down.

Hope this helps.

Pete

Hi Pete,
Yes it helps! will mark this thread as closed.

Thank-You very much

[Pete_UK]

You're welcome - thanks for the rep.

Pete