Prev: creating a report from a table, pivot table not suitable
Next: Rounding Up question
From: Wagnerk on 15 Apr 2010 11:05
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!
From: Mike H on 15 Apr 2010 11:13
Hi,

I suspect this is a format issue, format the cell as general
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Wagnerk" wrote:

> I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
> use to get the real number which is 12.85? Please Help!
From: Eduardo on 15 Apr 2010 11:15
Hi,
Format the cells as general

"Wagnerk" wrote:

> I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
> use to get the real number which is 12.85? Please Help!
From: Bernard Liengme on 15 Apr 2010 13:03
Suppose I have this:
A1 B1 C1
257 20 12.85 (C1 has =A1/B1)
I cannot see how formatting can give 12.00 - I can see how it could give 13
(with no decimals)
What formula are you using?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Wagnerk" <Wagnerk(a)discussions.microsoft.com> wrote in message
news:6DA26C0E-BFBF-400C-8FD2-A130C4739E30(a)microsoft.com...
> I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do
> I
> use to get the real number which is 12.85? Please Help!

From: "David Biddulph" groups [at] on 15 Apr 2010 15:29
I wonder whether you might have been using the QUOTIENT function instead of
dividing?
If you don't know what the QUOTIENT function does, look it up in Excel help.
If you want to divide A1 by A2, use the slant sign / to divide, so =A1/A2.
--
David Biddulph


"Wagnerk" <Wagnerk(a)discussions.microsoft.com> wrote in message
news:6DA26C0E-BFBF-400C-8FD2-A130C4739E30(a)microsoft.com...
> I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do
> I
> use to get the real number which is 12.85? Please Help!


 | 
Pages: 1
Prev: creating a report from a table, pivot table not suitable
Next: Rounding Up question