Creating A Fake Discount Calculator?

Nov 9, 2013

I'm very new to excel, my boss request me to create a discount calculator. A cost of price is given. We have a fix discount rate of 5% of that cost value. Some new customer want more percent of discount to the item they purchase. To deal with that, a markup price will be quoted then we will make a discount according to what the customer prefer but the final discounted value will be always be the discounted 5% of our cost value. I've problem creating it because as example; the customer request for 15% discount, when I add the cost + 10% then minus it back to 15%, the value I get will no be the same of the fixed reduced 5% value of my cost value.

ac16xpZ.jpg

View 5 Replies


ADVERTISEMENT

Conditional Statements Using IF: Get A Discount (no Discount) Not To Apply The 10%

Dec 22, 2009

I have attached a 2004 excel document that has a conditional statement that says, if an amount is over $400.00 you get a 10% discount, else, the cell says no discount. That is working fine. I also have a absolute cell ready to do the math for the 10% amount. There is also a column that shows the discount amount and column that shows the amount after the discount has been applied. Since I have been just doing one calculation and auto-filling, my problem is, how do I get the record that doesn't get a discount (no discount) not to apply the 10%?

View 4 Replies View Related

Creating A GUI Front End For An Elaborate Calculator

Nov 4, 2007

I have a very elaborate excel file that will calculate a price for our customized product. The user enters figures into about 15 fields, and hundreds of calculations take place and give the user a unit-price for that item.

Further, this excel workbook contains 3 queries to our enterprise database that get updated on opening.

What I want is to have a front-end GUI form that the user accesses like an html page that can be viewed internally by only users withing the intranet.

The main point here is that I have very sensitive information in the workbook. The last thing I want is for it to be emailed to our competition. Protection is not an option either, because I heard it can be easily cracked.

I want my user to access the excel spreadsheet without ever getting their hands on the original.

Maybe this thing should have been written in some other software package all along, but this is what I have to deal with.

View 9 Replies View Related

Creating Price Calculator Using Dropdown Boxes For Multiple BOMs

Apr 22, 2014

I am trying to create a price calculator for a particular product line which has multiple sizes and configurations. I would like to use drop down boxes so the user can select the size, type and attachments which will be narrowed down by the previous selections.

I would like the formula to be able to calculate the cost of the components based on the selections made. Based on some research I believe this can be achieved using data validation, indirect function and the vlookup function, however; I'm not quite sure how to go about this.

I have attached the document I have started for reference.

Chain Sling Price Calculator-4.xlsx‎

View 3 Replies View Related

Discount A Row

Dec 24, 2007

Is there a way to insert a discounted row at the top of an existing spreadsheet?

I'd like to name it "0" or "Row Zero" or "MasterRow" or something similar, such that the existing rows retain their original numbering, and none of the existing code is effected.

View 5 Replies View Related

Discount Based On Amount?

Feb 6, 2009

I need to create a price list a we give a discount based on the price of the product for example:....

All products over £100 have a 10% Discount, how do this and also at the sametime round the value up to 0.99p. ie Product ZXY123 is £123.99 10% off is £111.59 we need the calculated price to be £111.99.

View 2 Replies View Related

How Do I Discount By % (percentage) Not The Amount

Dec 3, 2009

how to get the discount to work the way I need to. As is, It requires a person to put in the actual amount that I will discount the product for each product sold. I would like to simply key in the discount percentage. EX: 10% or 13%

View 14 Replies View Related

Discount Check Macro

May 8, 2014

If I explain all the 8 steps , it will be lengthy and not easy to explain , thus I will go step by step

See file attached raw 01 , copy it on drive c directory called DISC , see file attached the result file

I want the the result file to go fetch data from the folder created DISC in which there is file called raw 01 and do the following with pulling headers , since the header is already plugged.

a to a
b to b
c to c
d is thus empty for the second step of the macro ( explain following after this fetching is achieved )
d to e
e to f
f to g
g to h
h to i
j to k
k it should not copy

View 5 Replies View Related

Discount Function In Macro

Mar 30, 2007

I have a quote system which takes data from tabbed sheets if there value is greater than 0, then does a simply formula which is then times by a discount which found by searching for the sheet name and then attaching the appropirate discount. In short this means that the whole forumale doesn't work and is not displayed

View 11 Replies View Related

Apply Discount After Calculations?

Jan 14, 2014

A customer has an overdue account, we will say in the amount of $500.00. We offer various discounts, 30%, 20%, 0% depending on the circumstance.

What I had previously worked flawlessly, that is until the higher ups changed how things had to be calculated.

Previously, we would take the amount owing and apply the discount (ie 20%) which would become the new amount due ($400).

We would then take the discounted amount and separate it into monthly payments:

$400.00
1st payment 60.00
2nd payment 60.00 (and so on)
6th payment 60.00
7th payment 40.00
Done.

The new way they want it calculated is (Same situation $500 owing, 20% discount).

$500.00
1st payment 60.00
2nd payment 60.00 (and so on)
6th payment 60.00
7th payment 60.00 *
8th payment 60.00 *
9th payment 20.00 *
Done

(*these would be the discounted amount, it would be stated that these payments would be removed if payments are made on time and in full yadda yadda).

The trouble I am having, is figuring out a way to tell excel to flag the specific payments. The reason behind it (i guess) is so that if a client becomes delinquent, the full amount owing would be sent to collections, not the discounted amount owing.

View 1 Replies View Related

Formula For Discount % According The Number Of Procedures

Jun 25, 2014

I need a formula to take away a percentage according the amount (number) ot procedures.

For example:

- procedure - price for one - 5 of it - 10% discount - final price

The idea is, for example, if I type amount of 5 procedures, automaticly to make 10% discount, if I type 10 procedure - make 15% discount etc.

View 6 Replies View Related

Calculating A Discount Based On Certain Rules

Feb 11, 2009

I'm looking for assistance with working out the following formula. I live on an apartment complex in Marbella Spain and we pay Monthly Community Fees of say $100.

We want to calculate a penalty amount for late payers of say 30% of the monthly fee due for non payers? So for instance if the monthly amount due in Cell D8 = 100 and the actual amount received in cell E8 shows 0 or then increase any figure due for the following month in Cell F8 should increase by 30% ($ 130) in the following month. and so on

I use Excel ver 2003. Trust my query is reasonably clear?

View 7 Replies View Related

Cost Price Vs Quantity Discount

Apr 7, 2008

I'm trying to work out how to get a spreadsheet to calculate when it works out cheaper to buy more of something, due to quantity price breaks, than less... e.g. 1-10 are £12.50 each, but 10-20 are £10 each and 20-30 are £8.75 each.. so it's as cheap to buy 10 (10x10=100) as it is 8 (8x12.50=100) and cheaper to but 10 (100) than it is to buy 9 (112.50) than 10... but there are similar price breaks at 20, 50 +

View 9 Replies View Related

Discount Formulas: Cells To Calculate $40 X (100%-10%) = $36

Jun 7, 2006

I would like to ask the formulas for this... for example:

$35 .. discount 10% + 25%

instead of having so many cells to calculate $40 x (100%-10%) = $36
$36 x (100% - 25%) = $27

View 2 Replies View Related

Discount Applied To A Cell And Rounded To Nearest Nine

Jul 10, 2014

I want to take the value in I and apply a 10% discount to it and place the new value in column M. Would it be possible to have this new value rounded up or down to the nearest 9.

Example:
Column I=7.99
Column M=7.19

Column I=7.59
Column M=6.83 (however I would need it to be rounded to the nearest 9. The price I would need would be 6.79)

Column I=2.19
Column M=1.97 (however I would need it to be rounded to the nearest 9. The price I would need would be 1.99)

View 3 Replies View Related

Track The Levels: Club Is 0 To 19 Points And Yields An 11% Discount

Jan 11, 2009

I have a 4-level program. The levels are Club, Bronze, Silver and Gold. Each is awarded when a certain amount of points are gathered.

Club is 0 to 19 points and yields an 11% discount.
Bronze is 20 to 44 points and yields an 12% discount.
Silver is 45 to 59 points and yields an 11% discount.
Gold is 60 and better and yields an 11% discount.

I am looking for a way to total the points and have the spreadsheet automatically calculate the leve and percentage. So if my total points is 22, I would need the formula to return "Bronze" in one cell, then "11%" in the next.

View 3 Replies View Related

Simple Form To Display Cost Based On Discount?

Jul 14, 2014

How would I create a simple user form to display a price based off the category selected.

User types in List Price, then selects 1 of 4 discount categories, it then displays that price.
An added bonus would be copying that price to another sheet, but not necessary..

View 2 Replies View Related

Figuring List Price - Cost To Show Discount Percentage

Apr 25, 2006

List Price $46.98 (e2)
Net Cost $19.53 (e3)

How do I enter a calculation that will show me my discount percentage from my supplier? (e4)

I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.

View 9 Replies View Related

Calculate Amount Of Days Paid In Advance And Apply Percent Discount

Jul 13, 2009

Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message.
give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount?

attached is the start of the assesment question.

You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid.

Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:
• If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.
• If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.
• If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.
• If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.

View 6 Replies View Related

Discount Prices Based On Order Quantity And Package Quantity

Nov 23, 2009

I have two idential spreadsheets with several rows of items each with different packaging quantities, price break quantities and corrisponding prices next to each break quantity. I'm trying to build a discounting sheet on an idential page by using formulas that read off the price sell in the same relative position on sheet 2. Below is one row of sheet1 and the idential row of sheet2 - underneath the cells are the rules I would like incorporate:

Sheet 1
ABCDEFG
1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3
210010.91000.744000.6

Sheet 2
ABCDEFG
1Pack QtyQty 1Prc 1Qty 2Prc 2Qty 3Prc 3
210010.91000.744000.6...........................

View 5 Replies View Related

Little Calculator Wanted

Jan 10, 2007

I've been trying but excel does not seem to recognise x and y

so here it is

2* X = Z

Where 2 is changable
X = Z-2

Now i just want to find what Z is.

Here's an Example
1.3x - z
1.3(x-.06) = z
1.3z - .078 = z
1.3z = z + .78
1.3z-z = .78
.3z = .78
z = .78/.3
z = 2.6

View 14 Replies View Related

Birthday Calculator

Jan 26, 2009

I am hopeless at remembering birthdays tbh - so rather than rely on family to remind me, I decided to make a spreadsheet that shows: D.O.B, current age (in years, months, days), and number of days remaining until next birthday.

Please see attached - I can't figure out why the current age calculation is a month out. e.g 'Sebastian' was born on 16 Nov 2008, which makes him 3 months and 11 days old - but '=TODAY()-C16' yields "00 Years 4 Month(s) 12 Days"

Also, 'Leah' has just her birthday - but now where it is supposed to give 'days until next birthday' it gives an error with the formula: '=DATEDIF(TODAY(),EDATE(C4,(YEAR(NOW())-YEAR(C4))*12),"d")'

View 6 Replies View Related

Freight Calculator

Nov 16, 2009

I'm building a freight calculator and am considering some professional consulting options, but before I do that I wanted to see if I could overcome this one problem. If I can, I think I might be able to complete the calculator myself.

Here's my conundrum:

A potential customer enters "80802" for zip code and "Solomon" for store.

StoreLocation_________ City_______ State_____ Zip______ Distance
Solomon__________ Arapahoe _______CO ____ 80802_____ 270
Garden City_______ Arapahoe_______ CO _____80802_____ 143

The formula (or series of formulas) I'm looking for would then refer to the following hidden sheet and return Arapahoe, CO and a distance of 270 miles from Solomon.

View 14 Replies View Related

Making A Calculator From Vb.net To Vba

Feb 11, 2008

i made a claculator in vb.net, and now i have to make one in vba, what i did was as follows, first ill post the code from last year, then my vba attempt;

View 14 Replies View Related

Progress Tax Calculator

Jun 19, 2006

I'm trying to come up with an efficient formulae or function to calculate tax

The problem I have is that the tax is progressive. As below

the first 20,000 is taxed at 5%
the next 20,000 is taxed at 6%
the next 20,000 is taxed at 7%
the next 20,000 is taxed at 8%
the next 20,000 is taxed at 9%
more than 100,000 is taxed at 10%

I'm trying to do a formula like below

Cell B3 is my taxable amount
Cell B5 =IF(B$3>20000,20000*0.05,B$3*0.05)
Cell B6 =IF(B$3>40000,40000*0.05,(B$3-20000)*0.05)

This gives me a problem in that for 35k say, I end up with a negative number for the second part in cell B6. My other issue is that each calculation will take up 6 rows on my
spreadsheet. I was hoping to set up a function that could do this in a cell, but even the simple stage defeats me at the moment.

View 12 Replies View Related

Timesheet Calculator

Dec 18, 2008

See workbook attached.

I'm looking for help to detemine rates so it automates in the sheet.

Can you give me assistance and code perhaps ? I'm pretty basic at V-Lookup and If functions. Is this the best route to take ?

All is explained within the workbook.

View 10 Replies View Related

Best Way To Implement Calculator?

Feb 20, 2014

Creating a calculator for employees and possibly customers to use to return values based on information inputted. Created a worksheet but thought there may be another way to enter and return the calculated information that may be more user friendly. New to user forms but thought that would work for the user to enter information. Can information be returned from the worksheet to the user form?

View 2 Replies View Related

Get Rid Of The Calculator Toolbar

Nov 25, 2006

I downloaded the calculator toolbar, and for some reason it doesn't look right, it doesn't resemble a calculator layout at all.

The numbers are skewed, as though the layout is in landscape view instead of portrate. I've tried repeately to delete it from the toolbars menu option, with no success. It's become annoying.

View 9 Replies View Related

12 Digit Calculator

Feb 20, 2007

Is there a way to build a 12 digit calculator in excel?

View 9 Replies View Related

Absence Calculator

Jan 30, 2008

im trying to put together a system on worksheets that checks 'Absence' in a rolling 12 month period. The 12 month period is any 12 months and not a financial period (eg 25/12/06 -25/12/07).

I have 36 employees and want to have their names in each sheet, calander dates across the top, will mark either a 'S' for sick or 'L' for late ect against the dates if not at work.

Once an absence has been entered, on the sheet somewhere it will show how many days that person has been off (eg, 10th Oct, 16 Nov and 22 Dec would = 3 Days absence).

How do I set up the sheets to work out how many days each person has had off in a rolling 12 month period (so that it does not calculate beyond the 12 months).

I have looked on here to see if there are any programs, formulas which may work but some have lost me in my tracks.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved