Results 1 to 7 of 7

advice required on ratio calculation formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    3

    Red face advice required on ratio calculation formula

    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
    Last edited by Slipa; 06-22-2017 at 06:08 AM. Reason: incorrect title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1