advice required on ratio calculation formula

**Slipa** · 06-22-2017, 05:50 AM

Hi All,

Excel Newbie here...

i work in catering and need to work out a simple calculation in excel regarding amount of catering to load.

The example i have is regarding a tray of desserts, the loading ratio is 1 tray per 20 people..

if i have 61 people then i need to load 4 trays in total, but i cant seem to work this out on excel, i tried division but this only gives me 3 trays ofcourse, (its probably super basic!)

I know i can do a look up but i would prefer not to as the menu/ratios are continuously changing.

appreciate any guidance on this

**cytop** · 06-22-2017, 05:54 AM

=ROUNDUP(61/20, 0)

Also:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**Slipa** · 06-22-2017, 06:14 AM

Hi Cytop,

thanks for the response.

How would i work out the below?

The scale i must load to is 1 per 45 passengers, the first flight is 42 so it only receives 1, the second flight is 48 therefore it receives 2..

Therefore the total i must prepare is 3, these figures can fluctuate.

appreciate your suggestion on a formula.

Capture1.PNG

**cytop** · 06-22-2017, 06:36 AM

Not sure exactly what you mean, and a sample workbook is a lot more useful than an image, but I'd assume that '1p45' means something like '1 per 45 passengers' - so change that to a number (or add another column) and just refer to that in the calculations. Sample attached, note the 'Relative' and 'Absolute' formulas. If you don;t understand what those are then you really should look them up.

**Wooodd** · 06-22-2017, 06:40 AM

Try This.

I have assumed that Flight 1 is in column F, 2 is G, etc.. and that the row is 4. If not just replace the references for the right ones

=roundup(F4/45,0)+roundup(G4/45,0)+roundup(H4/45,0)+roundup(I4/45,0)+roundup(J4/45,0)