Results 1 to 4 of 4

Adding Percentage in formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-17-2007
    Posts
    5

    Adding Percentage in formula

    Hello,

    I am using excel 2007 for costing material for construction. I have a pricing spreadsheet which I've converted to a table. Current column headers are:

    Description, Actual Material, Extra Material, Material, Material w/ Overhead

    Actual material = My cost of material
    Extra Material = Actual material + 15%
    Material = Actual material + Extra Material
    Material w/ overhead = Material + 25%

    I want to consolidate all 4 columns to one column utilizing a formula. Could anyone tell me what's the most efficient way to do this?

    Here's what I have so far but it comes out to be really long especially when you're working with tables on other sheets or named cells where the cell name would be much longer than just "A1" for example. In other words A1 would actually show as Materials!D31.

    A1 = Actual Material cost
    B1 = 15 % (extra material)
    C1 = 25 % (overhead and profit)

    Formula:

    =(A1+(A1*B1))+((A1+(A1*B1))*C1)


    Again, the above formula does seem to work, I'm looking for a more efficient way to write this formula.

    Thank you,

    -Travis
    Last edited by junkscratch; 09-24-2007 at 06:38 PM.

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