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.

Try something like

=SUM(a1:a100)-1400


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537583

Graham Moran Wrote:
....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)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537583

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.

"daddylonglegs" wrote:


Try something like

=SUM(a1:a100)-1400


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537583

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.

"davesexcel" wrote:


Graham Moran Wrote:
....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)


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537583