| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=(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 |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Linear Mode
