I have what may be a math question as much as an Excel question. See my attached spreadsheet example in which I grow the denominator of a ratio by a fixed percentage until it equals or exceeds the numerator. This results in the denominator being grown X number of times.
View 2 RepliesI have two columns of data, in another column I have the difference between these two columns, now I want to show the difference as a percentage. Assume cell A is 0.02 and cell B is 0.03 the difference is 0.01 and the percentage of the difference would be 33% or 0.01/0.03, my problem is when cell A is 0.04 and cell B is 0.01 the same formula wouldn’t work in both cases since in the first A<B and the second A>B is there a way that I can take the difference and divide it by the greater of A and B without having to do it manually?
View 6 Replies View RelatedI have a column of values. If a row's value is greater than 0, I want to count it as a value of 100 and add the result. I can get this far: =SUMIF(H11:H12,">0")
...but I don't understand what would come next. What I am trying to do is to use the above formula to total the actual sum of an array and then to also create a second column which assigns a maximum value total based on each row's non-zero result being worth up to 100. Using the above formula as a reference again, the formula that I am seeking would return a total value of 200 if both H11 and H12 contained any value greater than 0. I plan to use these two results then to calc a percentage.
I have a cell, M87. The score in M87 can be less than 13 or greater than 25. I need a formula within M94 which refers to M87, and outputs depending on the the following criteria. If M87 is less than 13 then output as D. If M87 is 14, 15, 16, or 17 then output as C. If M87 is 18, 19, 20, 21, 22, 23 or 24 then output as B. If M87 is greater than 24 then output as A.
View 3 Replies View RelatedIf A7 is equal to and greater than 95% than B7 is equal to "A". If A7 is equal to 91% but less than 94.99% than B7 is equal to "B"...
View 4 Replies View RelatedI'm trying to sum all values greater than 5,000,00 and less than or equal to 10,000,000. I have this formula:
Code:
=SUMIFS(B6:B1359,B6:B1359,">"&L2,B6:B1359,"=
I am looking for a function like MATCH if the match type were set to -1. However my data is sorted in ascending order. I am mining data from a Pivot Table, and it has dates across the top. Of course the pivot table will have the data sorted in ascending order from left to right. I want to find the first date that is greater than today. With weekends and holidays I can't just use TODAY()+1. Is there a function that can do what I am asking? Also I do not want to change the pivot table itself.
View 9 Replies View RelatedI need a formula that looks at the total in H40 and if the number is between 32 and 40 I need it to return the number then if the number exceds forty I need to multiply the overage by 1.5 and add it to the 8 for a total of 11.
I think it would be something like:
SUMIf(H40>"32",
I am creating my first Userform and having some problems. I take the data supplied by the userform and try to match it as closely as possible to a row of information. Currently I am using four cells to autofilter my spreadsheet data. Two of the cells I am looking for a exact match. The other two cells I am looking for the number that has been input or anything greater than it. Here is the code I have come up with...
View 9 Replies View RelatedI have 31 cells in a row (one for each day of the month. we collect data in these cells by typing "y" or "N". based on these input, cell 32 calculates the percentages based on total of Y's. Cell 33 has goal percentage. So, if the goal percentage is 30, Is there a way when a "y" or "n" is entered in cell 25, if the data percentage is = or 5% above the goal to get text message saying "good" but if the data percentage is 5% or more below goal, get a "not good" message?
View 3 Replies View RelatedHow can I count the number of cells in a range that contain values that are greater than or equal to zero?
View 2 Replies View Relatedi'm trying to create a markscheme progress sheet.
You take a childs actual age in months and years (ie 9.8 for 9years and 8months). They then, in theory, should be at that age level for reading and spelling.
I have the age in B4, the reading in C4 and the spelling in D4. If i use CF to say i want C4 to be red if it's less than B4, Amber if it's the same and green if it's over, as soon as i okay it, C4 goes amber, because it's equal to B4, which is blank. I can get the colours to work, i just can't figure out what to put to turn the amber off when cell B4 is empty.
I've tried as many combinations as my little amount of excel knowledge can cope with.
I have start date(Column A) and an end date(Column B) in two columns and I have found out the difference between them in column C in hh:mm:ss format. I want to find out how many cases are greater than 2 Hrs but less than or equal to 4 Hrs.
View 9 Replies View RelatedCan use an icon set conditional format to solve the following -
if I have an order figure in A1 and a received figure in A2 I want to show a tick in A3 if the received figure is within 10% either side of the order figure.
i have table of values if any value in the coulomb G and I greater than or equal to 1 the entire row must be deleted how can i do this ?
View 4 Replies View RelatedStarting in cell F3, if Column F is greater than or equal to zero, delete the entire row and continue deleting rows until Column A has contents in it. Then go to Column F in that same row that had contents in Column A, if the contents in that row of Column F are greater than or equal to zero, delete the entire row and continue deleting rows until Column A has contents in it. Persist with this pattern until every row in Column F has been checked.
View 4 Replies View RelatedNeed a formula for counting how many consecutive cells where the value is gretaer than or equal to +1
For example 1,
J18 = 7
K18 = 9
L18 = 3
M18 = 2
N18 = 8
O18 = 1
P18 = 8
Q18 = -17
In the above example the result would be 7
Example 2:
J12 = -22
K12 = 9
L12 = 4
In the above example the result would be 0 since the 1st value was -22
I am revising a spreadsheet to automate some cells and size cable for my job. I am currently using the VLOOKUP command to search a table for the proper ampacity and return a cable size based on the minimum circuit amps. The problem however is the VLOOKUP command searches for a number equal to or less than my circuit amps and returns this cable size. I need it to return a size equal to or greater than the minimum circuit amps. How do I get it to lookup something equal to or greater than the minimum amount?
View 9 Replies View Related"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...
I have two columns A and B. In each column are a list of numbers. I want to count the number of times the numbers in column A are greater than the numbers in column B and display it in the form of a percentage. An even easier way for me to do what I need is as follows...I have a third column (column C) that subtracts A from B...if it is a negative number, the cells in column C are autoformated to color the cell red. If it's a positive number, the cell is colored green. Is there a way I can count the number of cells that are red and divide them by the number of cells that are green to get a percentage?
View 2 Replies View RelatedI am using cell V7 to input the formula but I want cell V7 to tell me if the number in U7 is greater than or equal to the individual #'s in cells U7-U40 and I would like it to put a 1,2,3 in the cells of V7-V40 for the three highest numbers in order of largest to smallest if is this possible?
View 3 Replies View RelatedI want to display a warning pop up message when the following cells (Cell A1:A10) is greater and equal to 3.
I would like some code in VBA
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 3 Replies View RelatedI'd like all Cells in column AC (e.g. AC$3$:AC$517$) to be filled with yellow fill if the cell value is any date greater than or equal to today. Any past dates can be left blank (for now)
=$AC3>=TODAY()
SUMIFS with less than & more than
I found this thread which works for normal ranges
I want to Sum for Values Greater than a specific date in my formula.
This first one works for a specific date (Relevant reference in red), so say 01/01/2014
Code:
=SUMIFS(Table2[[#All],[Basic]],
Table2[[#All],[Cluster]],Table3[[#Headers],[Company]],
Table2[[#All],[Start Date]],Table3[#Headers],
Table2[[#All],[Perm / Temp / Prof / ETA]],[@Company])
Code:
To Sum for ranges >= 01/01/2014, I have tried this below based on the thread above but Excel does not accept this.
=SUMIFS(Table2[[#All],[Basic]],
Table2[[#All],[Cluster]],Table3[[#Headers],[Company]],
">="Table2[[#All],[Start Date]],Table3[#Headers],
Table2[[#All],[Perm / Temp / Prof / ETA]],[@Company])
I created a new form for our field personnel to complete daily. They are telling me that over a few weeks the file grows in size. The file size is 335KB starting out end up in a few weeks being 3.5megs. Now they add on some other sheets and things which undoubatbly make the file size larger but I am wondering if there is anyway thet VBA could somehow make the file bigger as the open it each day over a few weeks? They are not adding in any VBA, they are only using the code which is provided, which is accounted for in the 335kb. It seems unlikely but i thought i would ask.
View 9 Replies View Relatedusing the wrap text option for a cell, is it possible to have the cell grow and shrink along with its contents?
View 10 Replies View RelatedThe first of two consecutive numbers with exactly two simple denominator are:
14 = 2 × 7
15 = 3 × 5
The first of three consecutive numbers with exactly 3 simple denominator are:
644 = 2 × 7 × 23
645 = 3 × 5 × 43
646 = 2 × 17 × 19
I need to write a program that finds the first four consecutive numbers that contain exactly four simple denominator.
Is it possible to obtain the numerator and denominator from a fraction?
For example, I entered different numbers and display them as fractions in the cell using the format "?/?"
Is it possible to obtain the numerator and denominator from that cell and place them into a different cell?
ex: In cell [A1] is the value "1/4"
can i take the numerator "1" and place it in cell [A2] and the denominator "4" and place it in cell [A3]
By the way, I've tried using the functions LEFT and RIGHT but they display the value in it's decimal form. (example: RIGHT(A1, 2) displays the number "25" from 1/4=0.25 as opposed to "/4"
I am trying to make a condtional formatting to a cell, so that it will change colour depending on the time since the date in the cell. I am trying to check for Less than 6months, equal to 6months and greater than 6months.
View 4 Replies View Related