Results 1 to 11 of 11

Need Advice with creating formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2014
    Location
    Latvia
    MS-Off Ver
    Excel 2013
    Posts
    12

    Smile Need Advice with creating formula

    I wanted to make a formula in Excel
    try to tell...

    for example, I have a 5-storey house
    comes to the ventilation duct
    For each of these floors goes air duct, each floor its own duct
    This means if the air ducts in the attic begins, then the 5th floor in the attic there are 5 air ducts
    4 floor 4 air ducts
    3rd floor 3
    2nd floor 2
    1st floor 1
    one runs the length of the air on one floor 3m
    and I want to get the formula Excel
    order by entering the number of floors and floor height is automatically calculated as the total duct length by all floors
    this case it is 45 m
    1st floor is 3m
    2nd floor is 6m + 1st floor = 9m
    formula.jpg
    this how it looks like
    first one is with 5 floors
    second one is with 6 floors.

    I want to create formula witch by changing floor count, changes result
    Last edited by Edgars.Aronietis; 11-22-2014 at 04:05 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 07-16-2013, 10:32 AM
  2. [SOLVED] I want to create a formula in one sheet, that will function as a formula in other sheets
    By johnw993 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2013, 07:07 PM
  3. IF formula question:create a excel IF formula
    By Jonsby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2008, 07:12 AM
  4. Replies: 7
    Last Post: 08-22-2005, 08:05 AM
  5. Replies: 2
    Last Post: 07-01-2005, 02:05 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