Excel experts

Posted By Message

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Excel experts

how do I calculate this?

36 items at 199.99
30 items at 99.99.

what is the average price if each item?

to clarify it's 66 items, so what would be the average price and how do I calculate?

Message edited 2011-01-10 15:10:10.870000.

Posted 1/10/11 3:09 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

neener1211
:-)

Member since 4/07

22952 total posts

Name:
J

Re: Excel experts

what she said belowChat Icon

Message edited 2011-01-10 15:13:01.640000.

Posted 1/10/11 3:11 PM
 

november12003
Love my boys...

Member since 5/05

2412 total posts

Name:
Jenn

Re: Excel experts

36*199.99=7,199.64
30*99.99=2,999.70

Total of 66 items at an average price of $154.54 ((7199.64+2999.70)/66)

Posted 1/10/11 3:12 PM
 

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Re: Excel experts

thanks but that doesn't give me the average price per item.

Posted 1/10/11 3:13 PM
 

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Re: Excel experts

Posted by november12003

36*199.99=7,199.64
30*99.99=2,999.70

Total of 66 items at an average price of $154.54 ((7199.64+2999.70)/66)



yes, thanks.

It's been a long time for me and excel..

Posted 1/10/11 3:13 PM
 

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Re: Excel experts

oops..tell me if I did this right.

it's 36 items at 99.99 and 30 items at 199.99.

I got 145.41.

Posted 1/10/11 3:17 PM
 

Elbee
Zanzibar

Member since 5/05

10767 total posts

Name:
Me

Re: Excel experts

Posted by Blu-ize

oops..tell me if I did this right.

it's 36 items at 99.99 and 30 items at 199.99.

I got 145.41.



I got 145.44

36x99.99 =3599.64
30x199.99=5999.70
total = 9599.34
average of 66 items: 145.44

Posted 1/10/11 3:22 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Excel experts

I get $145.44, sorry rounded upChat Icon

Message edited 2011-01-10 15:22:31.907000.

Posted 1/10/11 3:22 PM
 

CunningOne
***

Member since 5/05

26975 total posts

Name:

Re: Excel experts

Posted by Blu-ize

oops..tell me if I did this right.

it's 36 items at 99.99 and 30 items at 199.99.

I got 145.41.



yes, I just did on my hand calculator and got 145.44. round off error is possible.

Posted 1/10/11 3:22 PM
 

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Re: Excel experts

I was making it seem harder than it was.

I was thinking some proportion with the difference of the two amounts..I don't know what I was thinking.

Posted 1/10/11 3:25 PM
 

ThePs1023
LIF Toddler

Member since 8/10

377 total posts

Name:
Rachel

Re: Excel experts

your original post you have 36 @ 199.99 and 30 @ 99.99

the second post you have it reversed...


Posted 1/10/11 3:31 PM
 

nrthshgrl
It goes fast. Pay attention.

Member since 7/05

57538 total posts

Name:

Re: Excel experts

Posted by ThePs1023

your original post you have 36 @ 199.99 and 30 @ 99.99

the second post you have it reversed...





Chat Icon Chat Icon Chat Icon Chat Icon Nice catch. It went over my head.

Posted 1/10/11 3:43 PM
 

Blu-ize
Plan B is Now Plan A

Member since 7/05

32475 total posts

Name:
Susan

Re: Excel experts

Posted by nrthshgrl

Posted by ThePs1023

your original post you have 36 @ 199.99 and 30 @ 99.99

the second post you have it reversed...





Chat Icon Chat Icon Chat Icon Chat Icon Nice catch. It went over my head.



yes, the second time I posted was right.

Posted 1/10/11 4:09 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
Excel Experts question? DRMom 5/26/10 1 Families Helping Families ™
Excel Experts-COME IN!! zeta1996 7/24/08 3 Families Helping Families ™
Excel Experts DRMom 7/9/08 5 Families Helping Families ™
Excel Wizards... nevermind! Lucky09 5/10/08 0 Families Helping Families ™
can you format a table in Word, the same way you can in Excel? randella 6/13/07 3 Families Helping Families ™
my excel freaking crashed- I lost 2 hours worth of work! Beth 1/24/07 8 Families Helping Families ™