Quotient How to?

  • Thread starter Thread starter Charles McNabb
  • Start date Start date
C

Charles McNabb

I need to divide one cell by another and get answer that
is not rounded to the nearest whole number. For example
when I use QUOTIENT: A1 is $105,000, B1 is $44,300,
using QUOTIENT in C1 gives me $2.00, I need the decimals
i.e. $2.37.

I get this and the sheet works great.

Charles
 
Still does not work, I get #VALUE!
-----Original Message-----
Don't use Quotient. Just divide. Eg:

=a1/b1

--
Regards,
Fred
Please reply to newsgroup, not e-mail





.
Click to expand...
 
All I get is #VALUE!
Is there a way to nest formulas? i.e. A1/B1 then Round
the answer to 2d.p.? I know this has to be possible, it
should be simple. Dividing Currency you need the d.p.
 
Hi
=ROUND(A1/B1,2) should do. The values in A1 and B1 are numbers just
formated as currency?. Or did you enter text strings in A1 and B1??

Frank
 
I wanted to divide cells in column C by cells in Column D
and get the answer in Column E. So this formula is for
E2:E15. i.e. C2 = Sold Price $105,000, D2 is SEV
$44,300, E2 = $2.37.

I ended up doing it like this:

=ROUND(C2:C15/D2:D15,2)
 
Back
Top