software

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: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=537583
Graham Moran Wrote:
gt; ....difference between a set number, 1400,
gt; and the total calculation of a column, anywhere between 1200 and 2000.
gt; I
gt; need to know how to create a calculation to show the numeric difference
gt; from
gt; the 1400 both positive and negative. Any and all help would be
gt; greatly
gt; 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: www.excelforum.com/member.php...oamp;userid=31708
View this thread: www.excelforum.com/showthread...hreadid=537583Thanks 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.

quot;daddylonglegsquot; wrote:

gt;
gt; Try something like
gt;
gt; =SUM(a1:a100)-1400
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread: www.excelforum.com/showthread...hreadid=537583
gt;
gt;

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.

quot;davesexcelquot; wrote:

gt;
gt; Graham Moran Wrote:
gt; gt; ....difference between a set number, 1400,
gt; gt; and the total calculation of a column, anywhere between 1200 and 2000.
gt; gt; I
gt; gt; need to know how to create a calculation to show the numeric difference
gt; gt; from
gt; gt; the 1400 both positive and negative. Any and all help would be
gt; gt; greatly
gt; gt; appreciated.
gt; here's an example say Range A1:A20 has your values
gt; in B1 enter this formula
gt; =1400-sum(A1:A20)
gt;
gt;
gt; --
gt; davesexcel
gt;
gt;
gt; ------------------------------------------------------------------------
gt; davesexcel's Profile: www.excelforum.com/member.php...oamp;userid=31708
gt; View this thread: www.excelforum.com/showthread...hreadid=537583
gt;
gt;