- Joined
- Aug 26, 2016
- Messages
- 2
- Reaction score
- 0
Excel Having trouble subtracting one cell from another and storing the result. Pls help.
- Thread starter Balamurali
- Start date
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!
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?