Excel Having trouble subtracting one cell from another and storing the result. Pls help.

[Balamurali]

How do I automatically subtract the values of entire column A and B and store it in column C?

 

[Becky]

Welcome to the forum

You can use a simple subtraction formula for that, and just copy it down the column.

If the issue is that you don't want a column of zeros when there aren't figures in columns A & B, then you could use an IF function like this:

=IF(OR(A1<>"",B1<>""),A1-B1,"")

Just copy it down the entire column and it will only perform the subtraction if there is a number in either one or both of the columns.

Hope this helps!

 

[Balamurali]

Thank you! But, wont I be able to automate the entire C columns to store the result of subtraction of A and B even if the cells are blank or if the values are to be entered in future?

 

[Becky]

I'm not sure I follow what you're asking...?