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
ADVERTISEMENT
Nov 8, 2013
I've started with an Attendance tracking template that I found in Excel. My company has implemented an attendance policy where each employee is allowed up to 10 points before they are terminated. A 1/2 point is given for arriving late or leaving early and a whole point is given for an unscheduled absence. The points stay on the employee's record for one year, after that time period it drops off their record. We want to monitor each employee's cumulative points.
So, I'm looking for a way to look back 1 year from the current date and add up the cumulative points over that period.
View 3 Replies
View Related
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
Oct 16, 2009
Demarcating an Unusual Series to club alike elements.
First and Foremost ...
Happy Diwali to everyone.
May this year bring peace and happiness to the globe less of terrorism and war-like situation..
Now back to the query...
I need to not only count the no of cheques used for a particular account but also understand to which Cheque Book they Belong to..
I have some cheque mentioned one below the other not neccessarily in series but they need to be clubbed to Series 1 and if not alike then the next Series i.e. Series 2 so on so forth..
I have atttached the file which can explain in better manner the exact requirement..
Please someone help me on this as I have burned enough midnight oil with no futile gains till now.
View 12 Replies
View Related
Apr 25, 2014
Using this formula for a bank account,
=IF(SUM(C2-A1+B1)=C1, "match", "NO match")
down a column of about 3000 rows, yields only one cell with an unexpected and probably incorrect response in G2 with a "NO Match" - where the math is correct ?
A B C D
63.58 0.00 -54.97 match
64.57 0.00 8.61 NO match
128.21 0.0073.18 match
201.39
Details:
Attachment is included;
temp2.xlsx
in a bank account file, where "C2" is the previous balance, "C1" is the current balance, "A1" is any check written, "B1" is any deposit applied.
View 2 Replies
View Related
Feb 2, 2010
I'm working on has me making a frequency distribution of the yields column. If you look at M6 on the spreadsheet i'm trying to use the formula:
=COUNTIF($I$6:$I$35, "<=L6")
to represent all yields that are less than or equal to 0, in the next box (M7) I want to represent all yields that are greater than 0% and less than or equal to 1%. etc until I reach 7%, however the original formula isn't working and I don't know whats wrong with it.
View 4 Replies
View Related
May 27, 2007
If I create a simple conditional statement in a cell:
=IF(A8="NX-QSNT",B8, "")
I get the expected B8 cell contents when "NX-QSNT" exists in A8, or blank when it doesn't.
If instead of qualifying this full string, I try to Search for the "-QS" string in that cell as the criteria:
=IF(SEARCH("-QS",A8),B8, "")
I get the expected B8 cell contents when "NX-QSNT" exists in A8, but I get "#VALUE!" if it does not find this "-QS" string.
I'm guessing it may be because SEARCH isn't actually returning a TRUE/FALSE response, but rather, a numeric one based on the position of "-QS". I tried using a numeric approach also, but this didn't help:
=IF(SEARCH("-QS",A8) > 0,B8, "")
View 9 Replies
View Related
Sep 2, 2008
I wrote a formula to recognise when a child equalled or bettered a club record (CR) in an event. However what I neglected to do and cannot work out is for the formula to recognise the new time as the new club record that will then have to be equalled or bettered from then on to be recognised as a club record. For example CR for 70 metres is 9.28 secs. Formula I was working with was IF(ISBLANK(B3),""),IF(B3
View 9 Replies
View Related
May 2, 2007
Is there a way of amending the following line of code so that it selects multiple data points in a data series in a chart (e.g points 14,15,16)?
ActiveChart.SeriesCollection(2).Points(14).Select
View 2 Replies
View Related
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
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
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
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
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
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
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
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
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
View Related
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
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
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
Mar 27, 2008
how to go about actually doing it,
For an old project which was a till system i had two sheets,a data sheet and till system sheet , the data sheet contained :
example:
column A - numbering of the data (to be used with V Lookup)
column B - product name
Column C - price
This would then be replicated in the next 3 cells for the next data category.
Till system then had a combo box which had a cell link on the current page and data from the data sheet and then i had a price column next to i (containing V Lookup formula) the price then changed depending on the choice in the combo box.
I want to incorporate combo box's in to this new project. If i can then get some kind of stock thing i intend on then using conditional formating to colour code stock levels to show severity of needing to order etc..
View 14 Replies
View Related
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
Apr 3, 2014
Im recieving an error saying that i have too many levels of nesting for my formula
Is there any way to rewrite the formula i have here?
=if(I1>99,0.5,
if(I1>89,0.45,
if(I1>79,0.4,[code].....
View 3 Replies
View Related
Sep 15, 2009
I am trying to use the command below to report what type of bonus is to be awarded. .05% - 1% bonus, commission based.
=IF(E7>=0.12,1,IF(AND(E7>=0.115,D11<=0.1199),".09",IF(AND(E7>=0.11,E7<=0.1149),".08",IF(AND(E7>=0.10 5,E7<=0.109),0.07,IF(AND(E7>=0.10,E7<=0.1049),"0.06",IF(AND(E7>=.095,E7<=.099),".5",IF(AND(E7>=.09,E 7<=.0949),".04",IF(AND(E7>=.085,E7<=.0899),".03",IF(AND(E7>=.08,E7<=.08499),.025, IF(AND(E7>=.07,E7<=.0799),".15",IF(AND(E7>=.065,E7<=.0699),".005")))))))
It is telling me there are too many levels. I am not an Excel expert, so I am trying to figure out an alternative to this command, I am sure one is available.
View 5 Replies
View Related
Oct 9, 2013
I have a report of employees' hours reported for the week, which I process payroll from.
I have sorted the spreadsheet first by employee number, and then by date. I have subtotaled each day's hours (with a formula rounding each day's hours to the nearest quarter hour).
I now need to add a subtotal of weekly hours, per employee number, and I cannot figure out how to do this.
Here is an example of what I want to do. I have highlighted the second subtotal I want to add to the spreadsheet, but have been doing the =sum(xxx) formula for each employee because I can't figure out how to subtotal again.
David L 9/30/2013 0005 360 6:00 A.M. 12:00 P.M.
David L 9/30/2013 0005 112 12:30 P.M. 2:22 P.M.
David L 9/30/2013 0005 115 2:22 P.M. 4:17 P.M.
David L 9/30/2013 0005 13 4:17 P.M. 4:30 P.M.
[Code].....
View 2 Replies
View Related
Nov 22, 2006
Right now, I've this pop up box which prompts users for passwords and user name for log in. They are two main users : Admin and User. Admin is the user which is allowed to see all sheets. While User is only restricted to user interface sheets.
The problem is for the "User" I want to restrict a view in the sheet
"ELEMENT". I wish to hide columns L to AI if "User" logs in. But if "Admin" logs in, I want no columns hidden. Everything must be visible.
Private Sub CommandButton1_Click()
Sheets("Main").Select
Dim strUser As String, strPword As String, strWs As String
Dim w As Worksheet, c As Range, r As Range
strUser = Me.TextBox1.Value
strPword = Me.TextBox2.Value
Select Case strUser
Case "User"
If strPword = "User" Then
Sheets("SMXINVENTORY").Visible = xlSheetVisible
Sheets("SMVINVENTORY").Visible = xlSheetVisible
Sheets("SMIINVENTORY").Visible = xlSheetVisible
Sheets("SMF1INVENTORY").Visible = xlSheetVisible..............
View 3 Replies
View Related
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
Aug 21, 2012
I have daily data that has columns for day, day of week, week end, month, year. I am trying to create a pivot chart that displays the data as a line chart day by day and as a secondary axis column chart by week.
View 1 Replies
View Related
Jun 24, 2014
How can I format a Pivot Table with 5 levels. I try to use the "Design" but it only format the first 2 levels of the Pivot Table. I need to distinguish each level with different colors. I think manually is a bit difficult.
View 6 Replies
View Related
