View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rebecca
 
Posts: n/a
Default How do I correct this formula?

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