equal

  1. wsnyder

    Divide Month Into Four Equal Parts

    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...
  2. F

    If cell contains "+" add 0.33

    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...
  3. C

    Need Yes/No formula

    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.
  4. R

    How to find the number of cells in a range (i.e. the size of the range) the sum of which is less than or equal to a certain number?

    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...
  5. S

    Formula Reeating Values

    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...
  6. P

    Vlookup formulas

    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...
  7. F

    CF issue, 2 cells contain formulas, can't highlight if equal?

    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...
  8. J

    VBA/Macro to filter for values greater than or equal to a selected cell value? Currently have one which filters on equal value...

    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...
  9. K

    Using Logical Formulae to determine if all cells are equal to or below a given number, and not blank

    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...
  10. V

    Simple IF

    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
  11. S

    If range formula

    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,"-"), "-")
  12. L

    Simple IF

    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!
  13. D

    Dividing a list into equal groups

    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
  14. P

    Is it possible for Instr to be started at the middle of a text?

    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
  15. hardeep.kanwar

    If Function with multiple criteria for tax calculation

    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...
  16. D

    Help with referencing

    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 :))
  17. T

    Help on Countifs with a less than or Equal to criterea

    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...
  18. O

    If Formula result is 0 then output value =" "

    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.
  19. B

    If statement

    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...
  20. D

    Setting a Criteria in Sumifs

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top