sum 0 cell value to return a blank cell

[mwvirk]

hello
I have 3 scenarios
1- if cell A1 contains a number and cell B1 is blank then =A1+B1 should not show anything in C1. not even the value of cell A1 or any other number and not even 0
2- if cell A1 contains a number and cell B1 is having the value of 0 then =A1+B1 should be the total in C1 (that will be the value of A1)
3- if cell A1 contains a number and cell B1 is also has value (with decimal or w/o decimal) then =A1+B1 total will come in C1 (that will be the value of A1+B1)

Actually, I am checking if company (stock market) is giving me right shares with or without premium
Value is cell A1 is always the actual face value but if there is premium then face value + premium will be calculated otherwise keep the sheet clean

Hopefully, my question is clean and I will surely get a solution. Please check screenshot. I don't want unnecesary numbers other than 2 valid values.

Thank you

 

[Joe4]

Based on your description, I think you just want a formula like this:

=IF(AND(A1<>"",B1<>""),A1+B1,"")

(though your description really does not match your picture).

 

[jtakw]

Hi,

May be, another way:

Book3.xlsx
	A	B	C
1	100
2
3	100	10	110
4	100	0	100
Sheet1021

Cell Formulas
Range	Formula
C1:C4	C1	=IF(B1="","",A1+B1)

 

[mwvirk]

Based on your description, I think you just want a formula like this:

=IF(AND(A1<>"",B1<>""),A1+B1,"")

(though your description really does not match your picture).

thanks a lot. this formula worked exactly what i was looking for. sorry for not sharing the sheet properly. here is the full rows.

 

[mwvirk]

Hi,

May be, another way:

Book3.xlsx
	A	B	C
1	100
2
3	100	10	110
4	100	0	100
Sheet1021

Cell Formulas
Range	Formula
C1:C4	C1	=IF(B1="","",A1+B1)

this didn't work for me. but thanks for your help.

 

[Joe4]

You are welcome.
Glad we were able to help!