1. N

    Countifs - Multiple Conditions (HR Dashboard)

    Dear Team, I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things: A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating...
  2. L

    VBA if else statement 3 conditions

    Good afternoon. I want to determine an amount of pay in local currency according to 3 conditions [frequency of pay]: (daily pay, monthly pay, one-off pay) If pay is in daily mode, amount of pay is : daily pay = daily pay * 5 * 24 If pay is in montly mode, amount of pay is: montly pay * 6 If pay...
  3. E

    Nested IF...THEN formula with multiple conditions: Rule of thumb on sequence logic?

    When creating nested IF...THEN formulas, is there a rule of thumb you use to design the logic sequence of conditions? I'm trying to address five conditions using a nested IF...THEN formula and could use some guidance. Alternatively, if you have suggestions on addressing five conditions using a...
  4. 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...
  5. 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...
  6. 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...
  7. 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"...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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) &...
  16. 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...
  17. 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?
  18. 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...
  19. 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...
  20. 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)

Some videos you may like

This Week's Hot Topics