+ Reply to Thread
Results 1 to 3 of 3

Budget Mark-ups dependent on certain total

  1. #1
    Registered User
    Join Date
    08-01-2014
    Location
    florida
    MS-Off Ver
    2013
    Posts
    1

    Budget Mark-ups dependent on certain total

    My boss has asked me to find a way to charge a mark-up on our project budgets based on a certain budget tier system ($0-1000, $1001-5000, $5001-10000, $10001+) He doesn't want a general percentage. Is there a way to do this is Excel?
    He was talking about Boolean functions, but he was also used to using Logic. I do not know logic or if there is any such function within Excel. I am self taught, and no expert. Any suggestions would be helpful.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Budget Mark-ups dependent on certain total

    Boolean is using things like AND, OR and NOT in different combinations....I would recommend looking up IF() statement and using an AND() together....

    EDIT: it would probably be a nested IF()
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Budget Mark-ups dependent on certain total

    Let's say the value you want to mark up is in cell C5
    on Sheet2 you make a little table in A2:B5
    0 8%
    1001 6%
    5001 4%
    10001 3%
    Then, in sheet1
    =C5 + VLOOKUP(C5, sheet2!$A$2:$B$5,2)*C5
    Is that what you are looking for?
    Attached Files Attached Files
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a YTD total for budget that changes as the months progress
    By abbacus in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-01-2013, 06:44 AM
  2. Creating a running total for a budget
    By venetian_jigsaw in forum Excel General
    Replies: 2
    Last Post: 07-11-2011, 02:34 PM
  3. Replies: 3
    Last Post: 03-16-2010, 01:26 PM
  4. Running total of budget
    By assistance in forum Excel General
    Replies: 8
    Last Post: 08-25-2006, 03:57 PM
  5. [SOLVED] How do I get Excel to do a tally mark total?
    By kurg99 in forum Excel General
    Replies: 2
    Last Post: 03-15-2006, 01:25 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