division problems in exel 2007

  • Thread starter Thread starter sid
  • Start date Start date
S

sid

whenever i divide two numbers using =quotient e.g-8.42 divided by 2 it
gives me the answer
4.00 instead of 4.21
why is that??
how do i change this?
 
From Excel help QUOTIENT:

Try it like this: =8.42/2

Or, using cells to hold the values:

A1 = 8.42
B1 = 2

=A1/B1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top