ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What formula should I use (https://www.excelbanter.com/excel-worksheet-functions/5220-what-formula-should-i-use.html)

Saskia

What formula should I use
 

Given a budget of $1,000, a particular brand of knickers sells in packs
of 5 for $10, how many knickers can each of ten persons receive if it
is shared equally?


--
Saskia
------------------------------------------------------------------------
Saskia's Profile: http://www.excelforum.com/member.php...o&userid=15810
View this thread: http://www.excelforum.com/showthread...hreadid=273227


Alex Delamain


=(Dollars/Unit_cost)*Unit_Qty/People

Unit cost = $10
Unit Qty = 5 pairs


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=273227


Bernie Deitrick

Saskia,

Your teacher will be disappointed if we help you...

Bernie

Given a budget of $1,000, a particular brand of knickers sells in packs
of 5 for $10, how many knickers can each of ten persons receive if it
is shared equally?




Jason Morin

A1: $1000 (budget)
A2: 10 (total people)
A3: $10 (cost per pack)
A4: 5 (knickers per pack)

=(A1/A2/A3)*A4

=50 knickers per person

HTH
Jason
Atlanta, GA

-----Original Message-----

Given a budget of $1,000, a particular brand of knickers

sells in packs
of 5 for $10, how many knickers can each of ten persons

receive if it
is shared equally?


--
Saskia
---------------------------------------------------------

---------------
Saskia's Profile: http://www.excelforum.com/member.php?

action=getinfo&userid=15810
View this thread:

http://www.excelforum.com/showthread...hreadid=273227

.



All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com