Need to know percapita consumer debt. Debt amount is 2121.1 bill.

Need to know percapita consumer debt. Debt amount is 2121.1 billions,
population is 295,622,256. How would I enter equation?

Put the debt value in A1
Put the population value in B1
Put this in C1 =A1/B1

Vaya con Dios,
Chuck, CABGx3


"cabe88" <cabe88@discussions.microsoft.com> wrote in message
news:023E4E00-D790-4F1B-8E59-1C27B370171E@microsoft.com...
> Need to know percapita consumer debt. Debt amount is 2121.1 billions,
> population is 295,622,256. How would I enter equation?

Debt in A1 $2,121,100,000,000

Population in B1 295,622,256

Formula in C1 =A1/B1 returns $7175.035


Gord Dibben Excel MVP

On Tue, 8 Mar 2005 17:13:03 -0800, cabe88 <cabe88@discussions.microsoft.com>
wrote:

>Need to know percapita consumer debt. Debt amount is 2121.1 billions,
>population is 295,622,256. How would I enter equation?

Hi!

A1 = debt amount
A2 = population

=A1*10^9/A2

7175.03

Biff

>-----Original Message-----
>Need to know percapita consumer debt. Debt amount is
2121.1 billions,
>population is 295,622,256. How would I enter equation?
>.
>

That's not the question. 2121.1 refers to billions, population is single
digits. Excel will not accept 2121.1 as a number, it hates punctuation.

"Biff" wrote:

> Hi!
>
> A1 = debt amount
> A2 = population
>
> =A1*10^9/A2
>
> 7175.03
>
> Biff
>
> >-----Original Message-----
> >Need to know percapita consumer debt. Debt amount is
> 2121.1 billions,
> >population is 295,622,256. How would I enter equation?
> >.
> >
>

Divide both sides of the input by 1000000000, as
=2121100000000/1000000000 for debt in A1, will display as 2121.1,
=295622256/1000000000 for population in B1 will display as .295622256

In C1 put =A1/B1 and still get 7175.035

Vaya con Dios,
Chuck, CABGx3


"cabe88" <cabe88@discussions.microsoft.com> wrote in message
news:E109E478-2138-448E-BAD3-AC4931866C7D@microsoft.com...
> That's not the question. 2121.1 refers to billions, population is single
> digits. Excel will not accept 2121.1 as a number, it hates punctuation.
>
> "Biff" wrote:
>
> > Hi!
> >
> > A1 = debt amount
> > A2 = population
> >
> > =A1*10^9/A2
> >
> > 7175.03
> >
> > Biff
> >
> > >-----Original Message-----
> > >Need to know percapita consumer debt. Debt amount is
> > 2121.1 billions,
> > >population is 295,622,256. How would I enter equation?
> > >.
> > >
> >

Hi!

2000 billion = 2 trillion.

Don't you like shortcuts?

2121.1*10^9 = 2,121,100,000,000

Biff

>-----Original Message-----
>That's not the question. 2121.1 refers to billions,
population is single
>digits. Excel will not accept 2121.1 as a number, it
hates punctuation.
>
>"Biff" wrote:
>
>> Hi!
>>
>> A1 = debt amount
>> A2 = population
>>
>> =A1*10^9/A2
>>
>> 7175.03
>>
>> Biff
>>
>> >-----Original Message-----
>> >Need to know percapita consumer debt. Debt amount is
>> 2121.1 billions,
>> >population is 295,622,256. How would I enter equation?
>> >.
>> >
>>
>.
>