equal

Hi all, Using Excel 2016. How can I divide any given months into 4 equal parts so I can determine if a task was complete in part1, part2, part3 or part4? I tried dividing 3/31/2019 into 4 equal parts of 7.75 hours each, but I don't like the way this is heading. There has to be an easier way...

anyone able to help me with the above. I have a column which contains numbers with + or - i.e. 4+ or -4. I want to convert these numbers i.e. 4+ would equal 4.33 and -4 would equal 3.67 - any ideas on how I can achieve this? If the cell contains a whole number i.e. 4 then the formula is to...

https://app.box.com/s/jcxrsue4vuzhnjzqhvzdfkdon20n1sm5 In columns ABC are digits ranging from 0-9, I need a formula yes/no that tells me if the largest digit is equal to the other 2 digits.

Hello, I have ranges of numbers in rows, and in each row, I want to find the number of non-empty cells in the range A:N, such that the sum of the range is less than or equal to 1000: <tbody> 87 98 100 69 91 99 83 86 79 95 87 63 90 85 =# of cells that sum up to 1000 (in this case 11) 92 90...

Hi everyone, Need a formula that will count how many zeroes appear in a cell range. Fro example, Cell Range A1 through D1 all equal 0 Cell E1 = 1 Total will be 4 Cell Range A1 J1 all equal 0 Cell K1 = 3 Total will be 10 Range is A1 through N1 I have the following formula below but will...

Hi again I have over 5,000 vlookup formulas in a spread sheet that is slowing down doing tasks. I thought of taking out the equal sign on all 5,000 of them and then record a macro while I put back in all the equal signs on all 5,000 formulas. This will create all the formulas in the recorded...

Hi All, I've done my due diligence and searched the forum before asking, however no luck. I have 2 cells (B5/B6) which count different columns. I want to compare their values, and if equal highlight $A$6:$B$6 No matter how I've written the comparison formula ie. =B5=B6, =$B5=$B6, etc, it...

Hi all, I have a very useful macro for filtering which lets me select a cell and filter a table based on that selected cell value, i.e., if cell B10 = 10, selecting cell B10 and running the macro filters that column for all cells containing exactly value 10. In recent time, I often find my...

Hi all, I am analysing some survey data and I am trying to group a set number of questions together so that I can determine if a patient has rated their pain equal to or below 4 (out of 10) for ALL of the chosen questions. An example of the data is below. As well as the formula I am currently...

Hello, I need help with a simple IF statement: If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2

Hello, How can i change the formula below to use a range for greater than/less than. I'm trying to say if k137 is equal to or greater than 6.5 but equal to or less than 0.5. =IF(K137>5,IF(AND(D152>=$L$12,D152<=$M$12),$J$12,"-"), "-")

Hello, I need help with a simple IF statement: If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2 I appreciate all assistance. Thanks!

Hi I am a bit stuck with this and i need a bit of help I have a list of products that needs to be divided into equal groups by Weight and Order value. I cannot add the img tag so i just leave the link below: https://ibb.co/XLWk4Yb Thank you

let say I have a text x="I am a happy man" If I set y=Instr(x, a), y is equal to 3. However I want y to be 9 which is the location of the "a" in "happy". How can I do

Hi Everyone I need help on "If" function I have multiple State codes, Tax rate, Amount and Tax applied i.e. IGST ,CGST,SGST,What i need if State code is not Equal to "DLH" Than tax should be IGST,if State code is equal to DLH than tax should be CGST AND SGST. <tbody> <tbody> State Code...

Hi all, I have this formula to reference a cell if it matches certain criteria - =if(A8=sheet1!AR$2,L8,””) What I also want to do is reference the cell if does NOT equal “sheet1!AR$2” Any help would be much appreciated :))

Hello I am trying to write a countifs where one criteria is a less than or equal to a number. =COUNTIFS('Rep Quotas'!$G:$G,Mapping!$AA4,'Rep Quotas'!$H:$H,Mapping!$Z4,'Rep Quotas'!$D:$D,"Field",'Rep Quotas'!$BQ:$BQ,"<="&Mapping!AI$1) Where: 'Rep Quotas'$BQ:$BQ can be null or have a number in...

Hello, I am wondering how will my formula below will output me " " (double space) if the resulting value of this formula is equal to 0 Formula: =IFERROR(INDEX(A:A,MATCH(C1,B:B,0)),"") Any help will be appreciated. Thanks in advance.

Sorry this seems simple but not working for me. I want to compare to see if c4 > n4. If c4 > n4 subtract n4 from c4 else put a zero in the cell This isn't working for me. c4 currently equal to 35,844 n4 currently equal to 24,852 P4 should be 10992 but it puts a dash in the cell. Here is what I...

I would like one of the criteria in my sumifs formula to reference a cell. I have discovered that if I enter, for example, A1, it works. But if I want the criteria to be not equal to A1 and I enter <>A1, Excel uses "A1" as the value, rather than as a cell reference. What is the proper syntax to...