Excel - Calculation formula

Posted on 2009-04-23
Last Modified: 2012-05-06
I have a table that i wouldlike to use for working out area sizes and the appropriate machine to use according to the results. What i have done is set it so that you input the Height (in C3), Width (in E3) and length in (G3). This will then give you the m³ value in I3. This is then multiplied by 10 to give the amount of air changes required for an area of the resulting size in I4. What i would now like to be able to do is input a formula based upon I4's total that divides it by each of the cmh totals (850, 2295 and 5850) and works out the least amount of NPU's required. So if the total in I4 is 1000 then the results would by 1 No 1500, or if the results was 700 then it would be 1 No 500 etc....Once the calculation has worked out what NPU requirement it is it i would like it to show the quantity required in G5 and the type of NPU in I5. If the result in I4 is say 26,000 the it will need to work out the lowest selection of NPU's that total so it would be 4 x 4000 & 1 x 1500.
Question by:Carlandrewlewis
    LVL 13

    Accepted Solution


    You'll need to reformat the sheet because I wasn't sure what you intended the final layout to be, but the solution is there:

    Author Closing Comment

    Perfect!! Thanks you for sorting this, i wasn't sure if anyone would be able to understand the question......

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now