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