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

G

Guest

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

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
G

Gord Dibben

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
 
G

Guest

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.
 
C

CLR

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
 
B

Biff

Hi!

2000 billion = 2 trillion.

Don't you like shortcuts?

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

Biff
 

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

Similar Threads

Calculation of Compounded Interest on a debt 6
Does anyone have a debt collection template? 0
Form Design advice 2
debt owed/ how to calculate payments with in time frame? 2
How do I put text and a cell reference in a text box? 3
If Yes, then Add question 2
How to run a 'total' query 4
Net Financing 4

Top