software

=(G6)-SUM(B6:E6)/G6 ...numbers are 10.29-(7.58)/10.29

Answer is .26 but Excel enters 9.55.

If Diffucult1 answers, thank you for your help on the previous forumula. It
really worked ... however, I figured out that I need a positve not a negative
answer.
The same idea applies; you've got to use parens to get the correct order of
operation: =((G6)-SUM(B6:E6))/G6 will force the subtraction before the
division. See the help on 'calculation operators', and check 'the order in
which Excel performs operations in formulas.'

quot;Rebeccaquot; wrote:

gt; =(G6)-SUM(B6:E6)/G6 ...numbers are 10.29-(7.58)/10.29
gt;
gt; Answer is .26 but Excel enters 9.55.
gt;
gt; If Diffucult1 answers, thank you for your help on the previous forumula. It
gt; really worked ... however, I figured out that I need a positve not a negative
gt; answer.
gt;
gt;

=(G6-SUM(B6:E6))/G6

or even

=IF(G6=quot;quot;,quot;quot;,(G6-SUM(B6:E6))/G6)

so you don't get an error if G6 is empty
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Rebeccaquot; gt; wrote in message
...
gt; =(G6)-SUM(B6:E6)/G6 ...numbers are 10.29-(7.58)/10.29
gt;
gt; Answer is .26 but Excel enters 9.55.
gt;
gt; If Diffucult1 answers, thank you for your help on the previous forumula.
gt; It
gt; really worked ... however, I figured out that I need a positve not a
gt; negative
gt; answer.
gt;
gt;