Add and Subtract functions

[Guest]

I am new to designing Excel Spreadsheets and I am trying to figure out how to
create a function that calculates the difference between a set number, 1400,
and the total calculation of a column, anywhere between 1200 and 2000. I
need to know how to create a calculation to show the numeric difference from
the 1400 both positive and negative. Any and all help would be greatly
appreciated.

 

[daddylonglegs]

Try something like

=SUM(a1:a100)-1400

 

[davesexcel]

....difference between a set number, 1400,
and the total calculation of a column, anywhere between 1200 and 2000.
I
need to know how to create a calculation to show the numeric difference
from
the 1400 both positive and negative. Any and all help would be
greatly
appreciated.

here's an example say Range A1:A20 has your values
in B1 enter this formula
=1400-sum(A1:A20)

 

[Guest]

Thanks daddtlonglegs,

Your equation worked perfectly and gave me the answer I needed. Hope to
work with you in the future when I need more help.

 

[Guest]

Thanks Dave,

I wanted to thank you for your help. The calculation worked but it was the
opposite answer that came up when I entered the equation that I needed. I
look forward to working with you in the very near future.