Simple question to avoid "0" cell value

Question

A	B	C	D
0	15	A1-B1=-15	-15
15	0	A2-B2=15	15
0	0	A3-B3=0	50
50	Blank Cell	A4-B4=15	Blank

In C1 if i enter Formula A1-B1 I get -15 answer, and if I drag fill handle I get answer in C2,C3,C4 as 15,0,0.How to get results as in D column>> -15,15,blank,blank.

Answer 1

Hi tkrajutkraju,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing.

And I appreciate your kind words.

Then you this: =FILTER(A1:A4 - B1:B4, (A1:A4 - B1:B4) <> 0)

Meanwhile, if you find our suggestions helpful, you can also use the feedback tool below our reply to submit your feedback for us (pictured below).

Have a good day and stay safe 😊

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Answer 2

Hi tkrajutkraju,

I appreciate your kind words.

If you are using Excel 365 or Excel 2021, the Filter function can use and both methods will yield correct results based on your conditions.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad

Answer 3

THANK you Waqas. Great reply. I have a table in which I would like to apply this function along with other two conditions, will it give correct results?

Answer 4

Thank you sir, formula yielded results what I need. I have just edited my question .Now my question is how to avoid that blank("") data what I am getting with your formula. In D1 if I enter your formula I am getting results as follows. from D1:D4>>-15,15,"",50. I don't need Blank cell value Results I need D1:D3>>>-15,15,50. No blank cell results.

Answer 5

Dear respected tkrajutkraju,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, in cell D1, enter the following formula:

=IF(A1 - B1 = 0, "", A1 - B1)

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad