What formula should I use

S

Saskia

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotal percents in pivot table 1
maintaining constant percentage 1
Excel - Wich Function should I use? 1
Scroll does not show preview 0
Help creating a sales commission formula 3
Fixed duration task and associated time budgets....help 0
First In First Out Function 3
Sumif with multiple sets of duplicates 4

Top