If/And formula

[Klhoyt149]

I am trying to say A+B=C, but if A and B are empty C is also empty. I think I have the formula figured out, but 0.00 still shows up when A and B are empty. Help, please.

[#2 · Accepted solution]

@Klhoyt149 

=IF(AND(A1="";B1="");"";A1+B1)

Example in the inserted file

I would be happy to know if I could help.

I wish you continued success with your Computer

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

It worked perfectly. Thank you so much.

[#4]

your welcome I am glad that I could help.