1. H

    largest, smallest, 2nd largest & 2nd smallest

    Posted on but could not got complete answer I need 4 formulae for: largest, smallest, 2nd largest (smaller than largest & non duplicate of largest) & 2nd smallest (larger than...
  2. D

    Nested if 3 conditions

    Hello, can you please help point me in the right direction on this formula. Basically it has 3 conditions depending on day count. If <60 it should return “80%” If >60 but under 180 it should return 75% And if over 180 it should return 65% I am trying this but it wont work...
  3. S


    I've discovered this thread from a little time, so if it's possible i post another doubt. I have this formula (really is longer but if a part is correct i suppose that all can be correct as well) =IF(D15<>0,5 +IF(E15<>0,5 +IF(F15>0,5))) I wanna have a total that give me a value if any,one,or...
  4. willow1985

    Help with if formula with multiple conditions

    i am hoping someone can help me with an IF formula that has multiple conditions. I have tried a few different ways but still I cannot get it to work. What I require is if A2="0" then return a blank if L2 ="0" then return a blank If A2>L2 return "Late" If A2 is <=L2 then return "on time"...
  5. R

    Event codes with two conditions

    Hi, Can you please help me get an event code with two conditions to generate a message for two scenarios as follows? 1) I am trying to translate this formula into VBA: IF(AND($A1="Home",$B1="School"),"Invalid Combination","") I want the event code to check these conditions for rows 1 to 20. I...
  6. C

    If statements with dynamic variables?

    I need to write an if statement based on some conditions which MUST be true and then other conditions of which any "4" (the value 4 needs to be an input by the user) can be true. However, I need the user to be able to determine which conditions are "MUST" conditions. I will have the user...
  7. J

    Vlookup with 2 conditions

    Beginning in Column H3, based on the value in column G3, I want to return the starting goalie for the game. So for game 1 I want to return "Pekka Rinne", Game 2 "Jusse Saros" from the array $A$3:$D$12 The linked picture of the example sheet, the eventual array will be 2000 rows...
  8. A

    Conditional Formatting?

    Hi everyone! I need to make certain cells on a report highlighted based on 2 conditions from raw data. Basically what I need is: If the date in range V2-V400 is today, AND the number in range Y2-Y400 is the same as say A2, then I need A2 to be highlighted. I've been told by a colleague that...
  9. G

    Conditional formatting and non-wildcard asterisks

    Hello all, I am looking to format cells that contain asterisks as part of the cell. So this is not a wildcard situation. I've got two types of cell conditions I want to highlight. Cells that contain asterisks will either start with 1 asterisk or 2 asterisks. I need different colors for both...
  10. R

    Issue with a formula (sum with conditions)

    Hi guys, We are talking about buildings, which is irrelevant, but it may be relevant only for your understanding of the issue. I have an issue with this formula. I need a formula that is able to sum the values based on particular conditions: 1) Based on the central cost 2) Based on CAPEX...
  11. G

    Conditional Formatting with Multiple Conditions

    I am trying to do some conditional formatting based upon 2 conditions. I have a column (S) that contains a number. I have a column (G) that contains a Y or N. I would like to highlight any cells in column G where it contains a "Y" and where column S in the same row contains the number 1. I...
  12. G

    Can I use conditional sections in VBA number formats

    I like the ability to use conditions, such as [<100], or colours, such as [Red], in custom number formats in cells. But can I use these, or an equivalent, using Format in VBA? My current requirement is something like this: shtCalendar.Cells(rt, cPlace) = shtEvents.Cells(r, cEventPlace) &...
  13. R

    Multiple Filter for a Column

    Hi, I am trying to add multiple filter in a column using macros. For Example: In a column, I want to filter cells containing apple and orange but not banana or guava. So there are 4 conditions. For 2 conditions, I am able to create below code but don't know how to extend this to satisfy all...
  14. V

    Need Help on an Excel project

    Quick question regarding excel: how would you extract data using multiple inputs but also add the ability to turn off any of the conditions with a form control?
  15. E

    Std Dev problem when using extra condition

    Hi, I need to calculate the standard deviation for 'Duration' data, based on 2 conditions in multiple columns that both need to be TRUE. I had some trouble but ended up using the DSTDEV command. I want to be able to avoid getting an error when there is no data that meets these conditions. I...
  16. M

    SUMIFS - 2 conditions, 1 column

    Hi, I'm trying to sumif one column with two conditions if possible. If I want to pull wte's total for all warehouses, it should be five. But when I put in the second condition to account for "whse 2", I get zero. Is it looking for both conditions in the same cell? How can I separate it to...
  17. N

    how to get the sum of a range in which two specific if conditions apply

    i have so far =SUMIFS(a2:b18, a2:b18, a2<b2)<b2)<b2) i want to get the sum in column a. in which b is greater than a. and a is greater than 30. example: a b 10 11 11 10 12 10 60 12 100 150 60 120 in this exmaple the sum should returns 110</b2)<b2)
  18. M

    VBA Challenge with conditions

    OK here the thing. I have created a sheet for my work that shows financial data. But this data I only want visible based on several conditions( possibilities) To make matters more complicated more than one condition can occur. Also These conditions are triggered by cell value based on a...
  19. B

    Count or Sum if three conditions are met

    I am trying to count or sum the total number of times that three conditions are met. I have three columns that I want to show the total number of times each column has the criteria I am looking for. I have it working but I have to pull it down each row and I don't want to have multiple formulas...
  20. P

    Add two conditions in excel Formula.

    Hello everybodey. I have finished my formula and till now its working everything, but i need to put a second condition inside that. Here is my formula to match a specific value in a row that have 2 conditions >=1.80 and <=1.9: Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))} I...

Some videos you may like

This Week's Hot Topics