Thread: How do I correct this calculation?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rebecca
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote