Excel experts
| Posted By | Message |
|---|---|
|
Excel experts how do I calculate this? 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
| |
|
Re: Excel experts what she said below Message edited 2011-01-10 15:13:01.640000. |
|
Posted 1/10/11 3:11 PM
|
|
|
Re: Excel experts 36*199.99=7,199.64 |
|
Posted 1/10/11 3:12 PM
|
|
|
Re: Excel experts thanks but that doesn't give me the average price per item. |
|
Posted 1/10/11 3:13 PM
|
|
|
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
|
|
|
Re: Excel experts oops..tell me if I did this right. |
|
Posted 1/10/11 3:17 PM
|
|
|
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
|
|
|
Re: Excel experts I get $145.44, sorry rounded up Message edited 2011-01-10 15:22:31.907000. |
|
Posted 1/10/11 3:22 PM
|
|
|
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
|
|
|
Re: Excel experts I was making it seem harder than it was. |
|
Posted 1/10/11 3:25 PM
|
|
|
Re: Excel experts your original post you have 36 @ 199.99 and 30 @ 99.99 |
|
Posted 1/10/11 3:31 PM
|
|
|
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... Nice catch. It went over my head.
|
|
Posted 1/10/11 3:43 PM
|
|
|
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... 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 ™ |








