Results 1 to 2 of 2

Thread: Change the name of a Cell to Text label using another cell and it uses anther value cell for calculations
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Change the name of a Cell to Text label using another cell and it uses anther value cell for calculations

    Hello I am using Microsoft Excel 2013.
    I am working on an estimating bill of quantities for Civil Engineering.
    In the Excel sheet 1 is the summary sheet 2 is the Office over heads and other costs sheet 3 is earth works sheet 4 concrete. In sheet 5 I want to build up the rates to use in each of the sheets.

    What I would like to do is in sheet 5 calculate the labour cost and material cost, together they would give me the total cost. I can then use this in any sheet for cost calculations. For example:

    In sheet 5: cell B5 is labourer cost of $15/hr B5=15
    In sheet 5: cell D5 is supervisor cost of $25/hr D5=25
    In sheet 5: Now I want L5=(B5*4)+D5 which = 85
    In sheet 5: G5=”Team A”,
    In sheet 5: I would like H5=L5 therefore H5=85, but the cell H5 must take the text label of G5
    In sheet 5: When I take G5 to a calculation in sheet 3 for example, the formula would look like this:
    Sheet 3 D4=”Team A”*2 Therefore D4=85*2=170 therefore D4=170

    If I can get the formula in sheet 3 to show the new label in the formula it would be easy for me when I come back to the estimate in a few weeks’ time to understand my thinking.
    Other calculations may look like the following:

    In sheet 3: E4=”Team A”+”Team B”

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    23,929
    Post Thanks / Like
    Mentioned
    406 Post(s)
    Tagged
    42 Thread(s)

    Default Re: Change the name of a Cell to Text label using another cell and it uses anther value cell for calculations

    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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