software

Hi All,

Can anyone help me with the following.

I have the formula =SUM(D2*(20/100)) which gives me the discount value
of cell D2 i.e if D2 = ?10 then the SUM = ?2

But I want the formula to work out the total minus the sum ie.

?10 - 20% = ?8

I hope ive made this clear, maybe im just going about it the wrong way.--
mdj101------------------------------------------------------------------------
mdj101's Profile: www.excelforum.com/member.php...oamp;userid=33739
View this thread: www.excelforum.com/showthread...hreadid=543304Try:
=SUM((D2*(1-(20/100))))
seems to work..
although only =D2*(1-(20/100))
will accomplish.
HTH

quot;mdj101quot; wrote:

gt;
gt; Hi All,
gt;
gt; Can anyone help me with the following.
gt;
gt; I have the formula =SUM(D2*(20/100)) which gives me the discount value
gt; of cell D2 i.e if D2 = 拢10 then the SUM = 拢2
gt;
gt; But I want the formula to work out the total minus the sum ie.
gt;
gt; 拢10 - 20% = 拢8
gt;
gt; I hope ive made this clear, maybe im just going about it the wrong way.
gt;
gt;
gt; --
gt; mdj101
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mdj101's Profile: www.excelforum.com/member.php...oamp;userid=33739
gt; View this thread: www.excelforum.com/showthread...hreadid=543304
gt;
gt;

mdj101 wrote:
gt; I have the formula =SUM(D2*(20/100)) which gives me the discount
gt; value of cell D2 i.e if D2 = ?10 then the SUM = ?2
gt; But I want the formula to work out the total minus the sum ie.
gt; ?10 - 20% = ?8

There are usually many ways to accomplish the same thing.
Perhaps the simplest for you to understand is to formulate it
exactly as you described, to wit one of the following:

=D2 - D2*20/100
=D2 - D2*20%

Note: There is no reason to use SUM() in this formula.
I am curious: why did you do it in the first place?

Also note: You might want to add some appropriate rounding.
What is quot;appropriatequot; depends on your goals and monetary
system. For example, one of the following (for US dollars):

=ROUND(D2 - D2*20%, 2)
=D2 - ROUND(D2*20%, 2)