How do I correct this calculation?
 

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.

How do I correct this calculation?
 

=(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

Trevor


"Rebecca" wrote in message
...
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.

How do I correct this calculation?
 

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.

"Rebecca" wrote:

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.

How do I correct this calculation?
 

A simplification to your formula might help

=SUM(B2:E2)/G2-1


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