ExcelBanter - Combining SUM Function with Nested If Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Combining SUM Function with Nested If Statement (https://www.excelbanter.com/excel-discussion-misc-queries/1319-combining-sum-function-nested-if-statement.html)

Somecallmejosh

Combining SUM Function with Nested If Statement

Is it possible to combine a SUM Function with an IF
statement that will allow me to add multiple cells, but
leave the cell blank if the answer is zero?

Here's what I tried, but to no avail.
In cell F5, I have the following formula:
=(SUM(C5:E5),IF(F5=0,"",(SUM(C5:E5)))

Is there something wrong with the formula, or is the
combination of functions/statements not allowed? Any
help would be greatly appreciated.

Sincerely,
Josh

Peo Sjoblom

=IF(SUM(C5:E5)=0,"",SUM(C5:E5))

Regards,

Peo Sjoblom

"Somecallmejosh" wrote:

Is it possible to combine a SUM Function with an IF
statement that will allow me to add multiple cells, but
leave the cell blank if the answer is zero?

Here's what I tried, but to no avail.
In cell F5, I have the following formula:
=(SUM(C5:E5),IF(F5=0,"",(SUM(C5:E5)))

Is there something wrong with the formula, or is the
combination of functions/statements not allowed? Any
help would be greatly appreciated.

Sincerely,
Josh

Frank Kabel

Hi
=IF(SUM(C5:E5)=0,"",SUM(C5:E5)

--
Regards
Frank Kabel
Frankfurt, Germany

"Somecallmejosh" schrieb im
Newsbeitrag ...
Is it possible to combine a SUM Function with an IF
statement that will allow me to add multiple cells, but
leave the cell blank if the answer is zero?

Here's what I tried, but to no avail.
In cell F5, I have the following formula:
=(SUM(C5:E5),IF(F5=0,"",(SUM(C5:E5)))

Is there something wrong with the formula, or is the
combination of functions/statements not allowed? Any
help would be greatly appreciated.

Sincerely,
Josh

CarlosAntenna

=if(sum(c5:e5)=0,"",sum(c5:e5))

Carlos

"Somecallmejosh" wrote in message
...
Is it possible to combine a SUM Function with an IF
statement that will allow me to add multiple cells, but
leave the cell blank if the answer is zero?

Here's what I tried, but to no avail.
In cell F5, I have the following formula:
=(SUM(C5:E5),IF(F5=0,"",(SUM(C5:E5)))

Is there something wrong with the formula, or is the
combination of functions/statements not allowed? Any
help would be greatly appreciated.

Sincerely,
Josh

All times are GMT +1. The time now is 12:30 PM.