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 |
=(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 |
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? |
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