Greater Than, If Cell Equals Specific Number.
I have students Kg5th Gr. I need to identify the ones overaged when I enter the information. The following is what I'm trying to use but I get Y1 for ever cell. I need it to Identify the student as Y1 for One year overage and Y2 for tow years overage.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Minus Number From Cell And Result In Specific Cell And Specific Column
I have number in cell (A1) = 100. when I enter number in any cell of column(B) for example (B1)=10. then in cell (C1) the result of (A1)  (B1) = (90) and if I add in cell (B2)=10 then in cell (C1) the result of (A1)  (B1+B2) = 80 .accumulatively in cell (C1). and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1) second question I have number in cell (A1) = 100. when I enter number at cell (B1) = 10 then the result would be in the adjacent cell (C1) = (A1)  ( B1) = 90 and If I enter a new number in cell (B2) = 10 then the result would be in the adjacent cell (C2) = (A1)  (B1+B2) = 80 and If I enter a new number in cell (B3) = 10 then the result would be in the adjacent cell (C3) = (A1)  (B1+B2+B3) = 70 and so on. I want the result to be add automatically to adjacent cell in column (C)
View Replies!
View Related
If Cell Has Number & Number Is Greater Than X
I have a spreadsheet that I need a formula so that when a number appears in one column, then automatically it will put text (only) in the adjacent column. I have attached the sample spreadsheet for review. What I need is if there is a number in column A then, put a " / " (forward slash) in column B. If there is only a 0.00 in column A, then put nothing in column B. I tried the IF function an it errored out stating that the " / " was not a number.
View Replies!
View Related
Record Greater Than 50 In A Cell So It Reads As Greater Than 50
I have to make a table that shows that a if someone purchases less than 5 items they receive no discount 510 items they receive 2% discount 1120 items they receive 5% discount 2150 items they receive 8% discount over 50 items they receive 10% and it has to be done in a way that the discount rate can be calculated using Vlookup I am struggling to find the best way to write this table. i tried numbering 1 to 50 and writing the corresponding discount rate in the second column but this looks untidy and can't calculate greater than 50 as i am not sure how to write it in the cell so it reads as >50 and not just 50.
View Replies!
View Related
Equals Last Cell
I have a sheet where there is a column showing all the totals of previous entries, however a couple of the cells shouldn't total but just show the last entry. The cell is for an ongoing count of year to date applications received. Can anyone tell me a formula that would look for the last data entered in a row and return that value
View Replies!
View Related
Add Specific Number Of Spaces To Text In Cell
I've got a single column worksheet with a varying numbers of characters in each row. At the end of each row's cell value I must add a 5 char string. Preceding that string I must have enough spaces to make the total length of each row 106 characters. I've already:Defined and populated the string. Let's call it "strMyString".Established how many rows are in the sheet and stored it in "lngUsedRange"Written the following which cycles through each row establishing how many spaces need to be added: Dim lngSpacesNeeded As Long For i = 1 To lngUsedRange lngSpacesNeeded = 101  Len(Range("A" & i)) Next i Now I just need to know what else to put before "Next i" to locate the end of the existing text in the cell and add the number of spaces in "lngSpacesNeeded" then add "strMyString".
View Replies!
View Related
Count Of Specific Number In Single Cell
I have a spreadsheet which has a column that contains route numbers (for collection of goods). Some addresses have 2 or 3 route numbers within the same cell i.e. 3 3 20 3 20 15 I would like to know the formula for counting the number of cells that contain each route number i.e. from above 3 = 3, 20 = 2, 15 = 1
View Replies!
View Related
Delete Row If Cell Equals
I am familiar with the macro DeleteRowOnCell, but I want to delete rows when a cell in a selected column has a formulae which is returning empty text. I tried the macro DeleteRowsFastest without success.
View Replies!
View Related
Conditional Number Format Based On The Value Of A Specific Cell
I have a large spreadsheet which includes many rows whose number format needs to change depending on the value of a specific cell. So for example: If cell B20 has value "A", cells Q20:AG20 should display as 1,234 If cell B20 has value "B", cells Q20:AG20 should display as 5.6% If cell B20 has value "C", cells Q20:AG20 should display as 7.89 Etc... As conditional formatting does not seem to include a number format option I've worked out that I need some sort of macro to change these settings for me, either automatically whenever the value of B20 changes or, more likely, when I manually choose to run the macro.
View Replies!
View Related
Delete Entire Row If Cell Equals
I have a row range 5:20004. In that row range column R may have 'QLD' in the cell. I am trying to delete all rows within that range that have QLD in column R or delete the row if R <> 'NSW' (would be a better way just in case there is something other than QLD) to do this on opening the file automatically.
View Replies!
View Related
If Cell Equals Then Image File
I am looking for a formula to allow an image file to show when a cell equals a certain text string. If it can be done can it be achieved with multiple images? I am making a database that will calculate from many variables my required glass sizes, given the size and window type and I was hoping to go one step further by making it raise a purchase order from a series of images and other related data.
View Replies!
View Related
Countif Cell Equals Active Worsheet
I need to enter a countif formula if a cell equals the name of the active worksheet and also cell A1. My worksheets are not always the same and I also want to be able to copy this formula to multiple worksheets so if the formula states active worksheet then is should work properly when I past it to multiple tabs (at least in my head)
View Replies!
View Related
Copy/Paste If Cell Equals A Word
I am trying to figure out how to go down a list of words and copy/paste a row if it equals a specific ring of words. For example, if want to go down a column and copy the word "Dog" if the word is "Dog" and paste it to the second sheet in a certain column... The thing that I can't figure out is how to step down to the next row until the cell is empty. Sub Cats_and_Dogs() For i = 1 To 100 If Range("i, 1") = "Dog" Then Range("i,1").Select Selection.Copy Sheet2.Paste End If Next End Sub
View Replies!
View Related
If Greater Number Msgbox
I like to do is if cell H3 is Greater than cell A35 to promt the message box below. But if less than do nothing. And if possible if less than to look at sheet 2 cell A35 and do the same. If WorksheetFunction.Sum(Range("H3") >= ("A35")) Then Exit Sub MsgBox "QTY. MUST BE GREATER THAN END FEQUENCY", vbOKOnly
View Replies!
View Related
Change A Cell To Being Locked When Cell Equals Certain Value
The spreadsheet is password protected. The only cells that students can enter values into are the answer cells. I am trying to figure out how to have a cell switch to being locked if the correct answer is inputted. ( I have a column that I hide that has the correct answers in it. Then I use a countif function to determine if the answer cell equals the inputted answer.)
View Replies!
View Related
Smallest Number From List But Greater Than 0
I'm using this =SMALL(A:A,1) in a cell but i need it to ignore the number 0. Because where theres no data it shows 0, but i need it to pick the lowest from the places where that data actually shows. something like this 0 0 54.2 0 82.6 0 0 55 So i need t get that 54.2 out of there.
View Replies!
View Related
Percentage Of Number Greater Than Other Numbers
"in Excel"  my formula for cell C11 is: "What percentage of the time (occurrences) was the value in cell B11 greater than the values in A1 thru A10?" As in...: 100 99 98 97 96 95 94 93 92 91 90...95.....40% 89...16.......0% 88...123...100% 87...90......20% So no data in first 10 rows of Col B. (Or Col C, of course.) Then for the value that appears in B11, how many times (out of 10, in this example for sake of ease) was that value greater than the entries in the first ten entries in Col A: 95 (cell B11) was greater than A10, A9, A8 and A7 (91, 92, 93 and 94). So 4 times out of 10, B11 was greater; 40% is the answer the formula would yield. 16 was never greater than any entries in A2 thru A11, so 0%. And 123 was greater than all the entries in A3 thru A12, so 100%. Etc, copied down the sheet...
View Replies!
View Related
How To Find Any Number Greater Then (x) And Replace With A Letter
how I could search for any number great then (x) and replace it a letter For example I have an excel table with a series of weights. lbs 6001 4560 6789 2000 5656 8879 1243 I like to replace any number greater or equal to 6001 lbs with the letters SS. Example: lbs SS 4560 SS 2000 5656 SS 1243 Then I'd like do the same thing again but this time replace any number less then or equal to 6000 lbs with the letters SSLL . Example lbs SS SSLL SS SSLL SSLL SS SSLL
View Replies!
View Related
Counting Number Of Dates Equal To Or Greater Than A Said Date
In my Excel spreadsheet I enter todays date in a single cell (A2), then I list various dates that jobs come into shop in other cells (A8:A108). I have cells ( F8:F108) where I have been manually entering an asterik (*) for those jobs equal to or greater than five days old in cell (A2). Is there a formula that can do the math for me? I've tried Excel help but to no avail.
View Replies!
View Related
Cell Equals Another Cell On A Worksheet
I'm trying to link data that is located on one spreadsheet and equal that to other information located in a different worksheet within the same file. See HPRP A Vital stats in E,F,G 12. I want to have the inforamtion from the spreadsheet Staff  Client Pre Screening in cell D,E,F,G 12. I tried the = function, but it is not working.
View Replies!
View Related
Formatting A Number Field To Hold A Specific Number Of Digits
I wrote an excel program in Excel'03 for a dental office to manage state assistance patients and one of the table columns is the state assistance number. The problem is that the program defaults to a number format when it is entered instead of a text format, which is what I want. The issue is that state assistance numbers are always 8 digits and when it defaults to a number field the program drops the required preceeding zeros. For example the number 00123456 will sometimes show up as 123456, which is wrong. It's like sometimes it will show up right and other times it gets a butterfly in its brain and deletes those zeros irritating the receptionist here. So, how do I get the table to either stay in text format or set up a number format that keeps the preceeding zeros?
View Replies!
View Related
IF Statement Within A COUNTIF Statement: Cell In Sheet "Summary" Count The Number Of Cells In Column DX Of Sheet "Analyses" That Are Greater Than 0
I am trying to have a cell in sheet "Summary" count the number of cells in column DX of sheet "Analyses" that are greater than 0, provided that the value in column A of "Analyses" corresponds with the value in B8 of sheet "Summary." (In "Analyses," there are 106 subjects, each taking up 64 rows. So, columns 164 correspond to Subject 1, columns 65128 correspond to subject 2, etc. In column DX, each subject has 64 values that are either 0 or greater than 0. In "Summary," each subject has one row that summarizes the 64 trials. I want a single cell in the "Summary," sheet to reflect the number of times each subject produces a value greater than 0 in column DX of "Analyses.") I tried using this formula, but it did not work correctly: =COUNTIF(IF(Analyses!$A$1:$A$10000=Summary!B8,Analyses!$DX$1:$DX$10000,""),">0") (Summary!B8 = 1, so I am trying to calculate the number of values in DX that are greater than 0 only for subject 1.) When I press enter, this yields a value of 384. This is impossible, given that subject 1 only has 64 possibilities of yielding a value greater than 0. Subject 1 has 2 values in column DX that are greater than 0. I tried making this an array formula by pressing Shift+Ctrl+Enter, and that just gives me a #VALUE! error.
View Replies!
View Related
Add 1 To The First Cell And See If It Equals The Next Cell
1016710 1016711FALSE Formula equals = sum(A1+1)=A2 1016712 1016713 1016714 1016715 1016716 1016717 1016718 When I viewed Evaluate Formula through Formula Auditing it seems to show my formula should work but the results come out negative when in fact it's True. Essentially I'm trying to add 1 to the first cell and see if it equals the next cell.
View Replies!
View Related
Macro To Copy Specific Cells From Row From Source & Stop When Next Row Cell = Specific Value
I have a protected template and unprotected source worksheets    what I would like to happen is for the macro to start and if the source worksheet cell B3 equals "Report Total" then stop  otherwise copy template worksheet then copy 6 specific cells from the source to paste values to specific cells on the newly created worksheet (B_ to C7, D_ to I7, E_ to C9, F_ to K9, A_ to C11, M_ to K11 and then K13=F1330) After that then start all over again unless the next row’s cell (B4, B5, B6, . . .) is "Report Total" then stop    the row count could be from one to a couple hundred. Here is what I have so far but I know that with each copy the name will change and as it goes down the source file each row will change and I also need help with that. Sheets("ee template").Copy After:=Sheets(3) ActiveSheet.Unprotect Selection.ClearContents Range("I7").Select Selection.ClearContents Range("C7").Select Sheets("source").Select ActiveCell.Offset(0, 11).Range("A1").Select
View Replies!
View Related
Run Macro If Cell Value Greater Than 1
I would like the macro to run on its own if the cell value is greater than 1 i have data comming into the excel sheet using sql, and j1005 cell calculates the entire data displays 1 if condition of j1005 is met else display 0 . the data refreshes on its own and j1005 keeps check every time and display the value 1 or 0
View Replies!
View Related
Copy If Cell Greater Then Zero
I have one sheet where I am entering the necessary parts of the particular order. Once I have it completed I need to run a macro to copy only the elements that I have marked. From rows 317, if cells in E3E15 are greater then 0 then I need the rows from Column "C" to Column "G" and Column "I" copied to another sheet. With rows 20  97 if cell in column "E" is > 0 then copy the relevant row from column "B" to column "E". I am attaching the file.
View Replies!
View Related
Create Formula To Add 0.2 To Cell Value If Its Greater Then 0
I want to create a formula which will add 0.20 to the value of a cell if its greater then 0. Basically i have a list of cells some of which will have a value and i want to sum this list and add 0.20 if there is a number in the cell. I am trying to create a quoting system and basically its a list of rooms etc with the wall lengths and i am adding 0.20 to each wall to allow for excess but for example if there are no measurements in bedroom5 i dont want the 0.20 added.
View Replies!
View Related
