Results 1 to 4 of 4

Formula depended from table with two diffrent units

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2014
    Location
    Sverige
    MS-Off Ver
    Excel 2013
    Posts
    21

    Formula depended from table with two diffrent units

    Hi, i don't have alot of experience in excel but im trying to learn on my own using youtube and google.

    Right now im trying to create a easy way to calculate the energy amount from the diffrent fuels. I have made a table with 40 diffrent fuels and the energy amount from all these. The thing thats makeing my calculation complicated is that not all fuels have the same unit. Some use volume (m3) and other weight (kg)(number 2).

    Right now right now I have managed create a scrollable numbered list and connected the numbers to a formula box i.e. when you find the right fuel you wright in the number in the formula box and the value and name of the fuel follow (number 1). The problem now is how do I connect the amount to the forumla box?

    In the formula box I two diffrent cells for the amount, one in m3 and the other in kg (number 2). How can i make a formula in (number 3) the formula box so excel understand what cell to multiply? How I didn't make it to hard to understand, follow the picture with the numbers. :)
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with a formula to look for unique combinations of 3 values from 3 diffrent
    By Anon2000 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-24-2013, 10:23 AM
  2. Replies: 2
    Last Post: 10-24-2013, 10:05 AM
  3. [SOLVED] Formula to get cell value under 3 diffrent conditionds
    By Sushil.thakur in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-29-2013, 02:57 AM
  4. VLookup into diffrent worksheets in a diffrent workbook
    By joffy1979 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-26-2013, 11:35 AM
  5. [SOLVED] Calculate the Bonus units according to the quantity of the units bought (Help)
    By mo_naf in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-15-2012, 05:51 PM

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