1. A

    VbA - copying different colum ranges depending on which condition is met & pasting into different sheet

    Ok, so I would really appreciate help as this has been driving me mad for over a week. Basically I have a raw data table where a customer can choose up to 3 different courses, data is in 3 columns. But I need to be able to have a complete table where if a customer selects 3 courses, her details...
  2. R

    Formula to score based on conditions

    Hello everyone ! I've been trying to solve this dilemma for a long time, but haven't been able to for weeks now after so many attempts. I would like the formula to make a scoring, based precisely on the criteria you see, and which are> or <50, and Growing or slowing, and based on how the last...
  3. L

    Formatting a cell based on multiple parameters

    Hello, I am looking to have a cell essentially put a in checkmark and green fill if a few conditions are met. It's a bit complicated so I will explain as best I can; The cell I want the formula in is U:9 The same sheet has 'important cells' B:9, I:9 and T:9 I have a list on a separate sheet...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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"...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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) &...
  19. 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...
  20. 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?

Watch MrExcel Video

This Week's Hot Topics

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