software

My formula is SUM(B2:E2)-G2/G2 ... numbers are (7.58)-10.29/10.29.

Correct answer is - 0.2633 but Excel keeps inserting 6.57 as the answer.

Please help ... trying to calculate Total Cost on ALOT of spreadsheets.

=(SUM(B2:E2)-G2)/G2

=((7.58)-10.29)/10.29

(7.58)-10.29/10.29 G2/G2 = 10.29/10.29 = 1; 7.58 -1 = 6.58

The division takes precedence over the subtraction hence 10.29/10.29 ( = 1 )
so put the additional set of brackets in.

Regards

Trevorquot;Rebeccaquot; gt; wrote in message
...
gt; My formula is SUM(B2:E2)-G2/G2 ... numbers are (7.58)-10.29/10.29.
gt;
gt; Correct answer is - 0.2633 but Excel keeps inserting 6.57 as the answer.
gt;
gt; Please help ... trying to calculate Total Cost on ALOT of spreadsheets.
Try this: =(Sum(B2:E2)-10.29)/10.29

I tried it in a spreadsheet myself, and I came out to the answer you were
looking for.

quot;Rebeccaquot; wrote:

gt; My formula is SUM(B2:E2)-G2/G2 ... numbers are (7.58)-10.29/10.29.
gt;
gt; Correct answer is - 0.2633 but Excel keeps inserting 6.57 as the answer.
gt;
gt; Please help ... trying to calculate Total Cost on ALOT of spreadsheets.


A simplification to your formula might help

=SUM(B2:E2)/G2-1--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=525896