if and formula with a twist - can you help?

[catts22]

Hi

I have a report which includes cells with formulas that include "" if not greater than zero, as I do not want zero value showing, only value greater than zero.

Now I need to take two of these cells and run another formula. My issue is if one of the two cells has "", I am getting "value" in my result cell (makes sense as there is no number in the cell).

So I came up with this, but it is not quite right, can you help?

=IF(AND(N23<>"",N25=""),N23,"")*IF(AND(N23="",N25<>""),N25,"")*IF(AND(N23<>"",N25<>""),N23+N25,"")

Thanks

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.