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.
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....
Let's say the value you want to mark up is in cell C5
on Sheet2 you make a little table in A2:B5Then, in sheet1
0 8% 1001 6% 5001 4% 10001 3%
=C5 + VLOOKUP(C5, sheet2!$A$2:$B$5,2)*C5
Is that what you are looking for?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks