column to take out a percentage of column A up to a set amount. So B takes out 100% up to $40 then C takes out 100% up to $20 etc.
how I can get my spread sheet do accomplish this.
I need some code to do the following.
Look at worksheet 1. Find column "Amount". Insert column next to amount.
For all highlighted cells in column "amount" insert text "R" in adjacent (inserted) column.
I have a spreadsheet with sales which I colour green when they are outstanding and red when they are despatched. I would like to automatically add a 1 in an adjoining column when the cell is green (eg outstanding) or zero when they are despatched so that it totals up the number of outstanding orders.
a b
172.95 (this column would be green)
024.00 (this cell would be red)
124.00 (this cell would be green)
132.25 (this cell would be green)
Trying to add a formula in my spreadsheet that will add every amount in column AQ8:AQ200 if the date in AQ8:AQ200 is march.
The format for the date is 3-12-09.
Here is what I'm trying.
=SUMIF(AU8:AU200,MONTH=3,AQ8:AQ200)
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 RelatedI need a formulas to add the row & column amount , see the attached example sheet.
Row and Colums.xlsx‎
I just need a warning box that indicates a user has entered a cell value under 200. Here's what I have but it's not working.
View 2 Replies View RelatedI thought it would be simple code. I have column C with amount such as
C1 : 3712.76
C2 : 277.91
When VBA runs, i want value to be rounded to display 3712 and 278 in C1 and C2 respectively.
Code:
Sub RoundC()
Dim N As Long, v As Variant, I As Long
Dim wf As WorksheetFunction
Set wf = Application.WorksheetFunction
N = Cells(Rows.Count, "C").End(xlUp).Row
For I = 1 To N
v = Cells(I, "C").Value
If IsNumeric(v) Then
Cells(I, "C").Value = wf.Round(v, 0)
End If
Next End Sub
This code working, but it end up value to 3712.00 instead of 3712 only. I do not want cell to display additional zero's.
what I am making error here?
I need a formula that will tell me how many minutes/hours are needed to hit a certain percentage.
For example, I need to do 60% of my time doing one thing (Team), and 40% of my time doing another (Individual). So, I need to know, if I've spent 5.5 hours doing Team, and 4 hours doing Individual, I need to know that I need to do .5 hours to hit the correct split.
I can't figure out what formula to use that will increase the current total to best figure out how many minutes I'll need to do either Team or Individual to hit the 60/40 split. It doesn't need to actually tell me 15 minutes, etc, but .25 would be fine (everything is done in .25 increments).
I'm trying to pull the lowest amount in one column if the values in 3 separate other columns agree.
View 3 Replies View RelatedIf Currency amount is less than $500,000 in column I, delete the whole row. I would like a formula to do the following...
View 2 Replies View RelatedI am trying to count the amount of cells in a column (Col H) containing data against a certain date which is displayed in another column (Col B)
Eg.
Col B................-...........Col H
13/06/09.................FIRST LAST
13/06/09.................
13/06/09.................FIRST LAST
20/06/09.................FIRST LAST
20/06/09.................
So that in the sheet next to it it would appear:
13/06/09 - 2
20/06/09 - 1
The dates don't appear in row order and the sheet has a filter on it so I am unable to select the Col H and just use COUNTA
If the value in Column H changes then move the value from it's original location which would be either in J, K or L from there to the column corresponding with the value in H (reference 1=J, 2=K, 3=L).
So, in the file, if H3 were to be changed to Priority 3 then I want the value to move from J3 to L3 and if it were to be changed to Priority 2 then I want the value to move from J3 to K3. The formula needs to work on all variations ie priority 2 changing to 1 or 3 for the whole sheet. There is conditional formatting - would be nice to keep it but no big deal.
My Column P (Payback) has amounts ranging from negative to positive. In one of my calculations, I would like to use the first amount in Column P that is positive.
Depending upon scenario, sometimes this could be P4 other times it might be P17
I have a worksheet where
Column D lists a service offered by a business, such as IMC, TC, Respite, etc
Column M lists how long the customer has used this service for in weeks, such as 4,5,3.5,6 etc
What I would like to do in another column is to count the number of clients who have used the service for 6 weeks or more broken down by the service type i.e. Count how many people have used IMC for 6 weeks or more.
If possible I would also like to be able to count those who have used a service for between 5.1. and 5.9 weeks too, again by service i.e. Count how many people have used IMC for between 5.1. and 5.9 weeks.
I have two columns (let's say column A and C), i would like to add the values in column A only if they are higher than the ones in Column C in the same row... how could i do that?
The sheet looks something like this, i would like to add the values in the first column only if they are higher than the ones in the third column and then of course get the sum of them... i would also like to know how many were there in total, but i guess i could do that with a count formula i just need the parameters
$ 67,100.00 $ 110,000.00 $ 165,100.00 $ 146,034.00 $ 239,400.00 $ 220,100.00 $ 90,184.69 $ 147,843.75 $ 168,500.00 $ 51,011.25 $ 83,625.00 $ 95,100.00 $ 89,860.32 $ 147,312.00 $ 198,200.00 $ 159,121.36 $ 260,854.69 $ 26,000.00 $ 129,941.44 $ 213,018.75 $ 235,700.00 $ 88,869.38 $ 145,687.50 $ 95,600.00 $ 27,772.54 $ 45,528.75 $ 43,000.00
I know a bit about excel nut not a hugh amount! i need to know a formula that adds the number of rows used in a column. Does that make sense?? ok
NAME
rob
dave
jim
darren
adam
lee
i need a formula that will tell me there is 6 rows used in that column (not including the title).
I know a bit about excel nut not a hugh amount! i need to know a formula that adds the number of rows used in a column.
NAME
rob
dave
jim
darren
adam
lee
i need a formula that will tell me there is 6 rows used in that column (not including the title).
I type in a "O" into the little grid I made and then the locations are placed into cells A34, A35, A36 and so on. The arrow I placed into column B. It works if I manually enter anything into A34,A35,A36 and it stays with the data. If I let the grid automatically populate A34, A35 and so on, it will not grow as the cells in A34, A35 are automatically populated. How can I make it do that one little thing? Sorry if I am confusing.
View 11 Replies View RelatedI have excel sheet which is having following format
sr no | bank | branch | chk no | amount | party | bill no
1 | combobox1 | combobox1 | 123456 | 12000 | combobox1 | 123456
2 | combobox2 | combobox2 | 12346 | 2000 | combobox2 | 123456
3 | combobox3 | combobox3 | 12345 | 900 | combobox3 | 123456
4 | combobox4 | combobox4 | 13456 | 7000 | combobox4 | 123456
5 | combobox5 | combobox5 | 3456 | 18000 | combobox5 | 123456
When i try to sort amount column it need to sort and change with corresponding row but it is not happening so what should i need to do for that ?
I have a column (L18 - L32) which consist of 15 cells.6 of these cells are colored(different colors) and the rest are blank.Im looking for a formula which will be able to count the amount of colored cells in my column.
View 9 Replies View RelatedI am trying to count the amount of times 4, 5, and "11-5" show up in a column and sum it at the bottom. I tried
=sum(if(c4:c41="4"+c4:c41="5"+c4:c41="11-5",1,0)
As an array and keep getting N/A. So im not sure where my problem is.
I have a spreadsheet containing 10,000 + entries.
Each Entry is Dated within Column D2:D10786 in this format - 1-Nov-08 (example).
Lets say i have a cell on another sheet Cell A1 and in this Cell i want it to Count how many Cells contain the dates from Nov-08 in my Date column..
I have a four column listbox where 4th column is percentage. In my source worksheet cells are formatted as percentage but when this is displayed in list box it shows approximately 10 decimals or maybe even more. How can I change my code only to show two decimals in 4th column?
View 3 Replies View Relatedi would like to copy my sheet 1 column K which has format cell in percentage and copy over to sheet 2 column K. But it will display decimal places rather then percentage. below code is i use to copy and paste special value. but its not workin.
View 5 Replies View RelatedI need to do the following:
If column X is less then < £1000 will have a 15% increase, those less than < £1500 a 12 % increase and any figure greater than > £1500 a 10% increase.
I could easily do this using a case statment using VBA, but im not allowed, any idea of a formulae that would do it?
i had a basic spreadsheet for my incomings and i got wiped with my hd exploding!! i know how much the total was i just need a way of creating a list of random amounts within a specified range over a year to give to my accountant.
I have a long column of numbers that I want to apply a single percentage to all the numbers in each column. How do I do that?
View 3 Replies View RelatedI want to track a friendly competition of squash games with a friend.
player1
player2
January
[Code].....
I have a simple column chart showing the progress of each month but I'd like a 13th pair of bars showing the percentage, with the percentage scale on the secondary axis. Do I have to choose the percentage cells as a separate series?
I would like to figure out a formula that will calculate what percentage of a column is filled based on the total number of rows.
For instance if I have Column K and that will have delayed savings by sales pursuit, I want to be able to calculate the percentage of what is being delayed from a total number of pursuits (basically the count of rows in column A). Ideally this would be a dynamic range (offset).
Ex. Say I have 25 rows in column A, but I only have 2 rows in column K filled. How can I calculate that there is a 8% (2/25) delay?