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

Joined
Aug 26, 2016
Messages
2
Reaction score
0
How do I automatically subtract the values of entire column A and B and store it in column C?
 

Attachments

  • PCRev_D1.png
    PCRev_D1.png
    100.4 KB · Views: 151

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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!
 
Joined
Aug 26, 2016
Messages
2
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top