if then

  1. S

    If X in C4, copy to E4, Dependent Validation

    I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns...
  2. J

    Nested IF in Sliding Scale Formula

    Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...
  3. K

    If Cell Contains Hyperlink Count

    Hello I am trying to construct a vba macro to count everytime a cell contains a hyperlink in range of data. Currenly having it search the row for a hyperlink and then if it finds a hyperlink it will count and not delete the row, deleting the row if it doesn't contain a row. I am currently having...
  4. K

    If Variable is Odd then

    I am having trouble writing a code to recognize if a number is odd or not and then determining what to do from there... It keeps pooping up with an "object required" error. Please let me know how I can fix it, or if you have ever come across this problem. Here is my code STNDRD=17 If STNDRDR...
  5. S

    VBA: SUMPRODUCT(CountIf) Help

    Long time lurker, finally broke down and made an account (1st post). I am in need of an if then statement in VBA. What i need it to do is count how many times each cell in Range B is in range A and does that count equal 10. the following is the formula that works in excel but not in VBA...
  6. J

    attempting to delete rows not containing certain text but having issues.

    Basically im trying to filter a large set of data. I have people's names and want to delete all rows not containing these names. I used this macro originally: Sub DeleteRows() Dim Cell As Range, cRange As Range, LastRow As Long, x As Long LastRow = ActiveSheet.Cells(Rows.Count...
  7. C

    Barcode Scanner Macro

    I'd like to setup some sort of a macro in excel with a barcode scanner I have. We have a factory with a large number of machines which are all bar coded that also have travelers with the production order in a barcode format. Right now someone walks the line and manually writes which work order...
  8. 7

    Formula needed

    Please can anyone help me to make a formula for this sheet? Thanks in advance!
  9. M

    Create "if then" statement in button click

    So what I am trying to do is when a button is clicked, depending on if a certain cell contains a text, will bring up a certain userform. So if "I6" has a date in it, userform1 would show. If "I6" and "I10" have a date in it, then useform2 would show. If "I6", "I10" and "I14" have a date in it...
  10. P

    Array with If Then

    Hello, I have a slight problem. I want a macro that can check if a value on sheet 1, column B matches one of multiple values in sheet 2, column B on and if so make the cell on the first sheet turn green. I need this to compare batch codes and to quickly see what ones have been approved. Only I...
  11. M

    Conditional Formatting

    Hello, I have a workbook with 2 sheets, sheet one has column I. Column I is filled with Percent's. Sheet has cell B2 filled in with one of the following "Jan, Feb, March, Apr, Jun, Jul, Aug, Sep, Oct, Nov, Dec." The Conditional formatting formula I thought would be something along with lines...
  12. T

    If one column has X, then replace all instances of (a word) in another column

    Your help would be so appreciated if you feel it, thank you. If Column "E" has an "S" or "U+U" in the cell, then REPLACE the instance of "Favorites" in that row's Column I with: <tbody> "FAVORITES 1 (Solos/OCs/twins only)" Similarly, If Column "E" has an "D" in the cell, then REPLACE the...
  13. G

    Write and IF THEN if cell is between two times

    I receive a large file each month which tracks staff who badge through a particular badge reader. I am trying to write a formula to tell me if each row was captured during regular business hours or not. below you see a paste of my excerpt (I cannot attach a sample excel file to this for some...
  14. T

    If cells contains this, do this until...

    Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me. Question: If cell's contains this do this until... Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first...
  15. J

    Type mismatch on cell values after VBA update

    Hello all, I'm hoping to get some help with the following issue. I've written a set of macros around a few worksheets that I analysed for a thesis project. The project is now finished but I'm doing some follow up work and thought it would be safe to update my Office 2016 for Mac now. After this...
  16. C

    vba to add col C value if col A value contains

    Hi guys, i am trying to write a vba to add values of col c (Weight) if the value in column a starts with a "W" and numbers after the "X" is less than 30 then add them all up and put the sum in cell H2(under Light). I've been working on this for a few days and cant quite figure it out, the...
  17. W

    IF and Statement?

    Hi, Please help.. Need a formula. I couldnt make the string?:confused::confused: i NEED FORMULA ON "H" that will output the following scenario? many thanks <tbody> A B C D (TOTAL b &c) E F G H 1 0 0 0 0 0 0 0 NO DEMAND 2 0 10 10 20 20 0 20 In Process 3 15 0 0 0 15 0 15 Need to Order...
  18. C

    Move on if not found

    Keep in mind I'm self taught so please excuse any ignorance of mine. Background: Daily, I receive a report that consists of 20-25 text files, 1 for each state we have business in. I have a process that consists of a few different scripts run one after the other. It does a lot to the files...
  19. L

    If Then Function Error VBA

    Hi, I have this code and it shows me "Object doesn't support this property or method" I dont know if anybody knows waht might be the mistake! Sub Horror() Call LastRowPivotTable With ThisWorkbook Set wb = ThisWorkbook Set DR = wb.Sheets("Draft") Set PT = wb.Sheets("Pivot Table I") MasterAcct...
  20. L

    If Then VBA searching on Pivot Table

    I have this code but sometimes it may search for a data is not, so I want a IF THEN formula maybe if it doesnt found anything it can still work, or maybe IFERROR Sub PivotTableFilter() Dim MasterAcc As Variant MasterAcc = Workbooks(Wk_Name).Worksheets("Draft").Range("C4").Value With...

Some videos you may like

This Week's Hot Topics

Top