ifthen

  1. E

    How to use VBA to do Conditional Formatting (NOT applying VBA)

    I have two sheets. Sheet 1 looks like this: Sheet 2's layout is exactly like sheet1's, but rows' sequence may change and some $ amounts may change as well Currently, I am using this VBA code to compare and contrast two sheets, then highlight the differences. Sub Try()...
  2. T

    Need to changed the value in a cell based on another cell with multiple values options

    I need aformula that will auto populate like this: If A1 shows “M”,then auto populate in A2 “T”, or “T” , “W”, or “Th”, “F”, and so on. I was tryingto write an “IF” statement, and then a VLOOKUP, but I am not good at writingthese formulas. Could anyone assist in helping write this. I...
  3. L

    how to concatenate if text starts with qvs* only for multiple columns

    Hello, I’m stuck in a situation where I need to be able to use VLookup to pull information based on text strings that all start with qvs. I’ve used normal concatenate across the 5 columns in question but it returns too much information and my vlookup formula errors. Is there a way to write a...
  4. T

    VBA Help: Using *Insert Row* to adjust distance between random distance of Row A to cell containing "ID #"

    I'm a bit new to VBA. But, I've gotten pretty far into this project at work. However, I've come across a logic problem that I don't have a knowledge base wide enough to complete: The problem goes like this: I have many Work books that I need to export to a master WB one at a time (this wb then...
  5. K

    VBA Help, Find, Copy & Paste

    I'm very new to VBA and figuring it out through YouTube videos and online google searches. I'm having some problems finding out how to do an If Then statement in VBA. I have the same text that can be found in either cell A47 or B47. The text is "Other." I want to do an If statement that says...
  6. W

    If value = 0 then do not add iRow to table?

    Hello! I have a "Ship" button with a macro that copies filled out rows in an order form and adds them to a list of shipments in another workbook. In Workbook A, there is a table of part numbers and their quantities, referred to in the code as iRow. Sometimes I have to make partial shipments, so...
  7. A

    Macro Help

    Hello everyone. I am a new user and a beginner in Excel's VBA. I was wondering how to create a macro that searches for a specific text, and any value associated to that text will shift over to a certain column. I would assume I would need to use an If Then statement, but like I said, I am very...
  8. P

    If match then display 0 or 1

    <tbody> ID FULL ID LEFT ID RIGHT ID TYPE 1234 1234 1 2345 2345 0 3456 3456 0 6234 6234 1 4657 4657 1 6879 6879 1 1243 1243 1 5436 5436 0 7896 7896 1 4894 4894 0 </tbody> I am having trouble getting the values in Column "Type". So the idea here is that...
  9. 1

    Nested If Then Question

    Hello, I am having an issue with an Nested IF THEN statement. I am hoping you can assist. The formula i have is located in DR4 `=IF(DF4="0","",IF(R4="PC",((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4)),((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4))*V4)/1728*7.48) the goal is to look at DF4 if its zero...
  10. M

    IF THEN across multiple pages, for multiple values

    Hello, I am having trouble writing a formula for the following: I have values in cells D2:D5 in Sheet 2. If the number is >99 in each cell, then I would like a value of 1 to be assigned. If it is <99, I would like the value to be 0. I would like to count these individually (i.e. line by line)...
  11. F

    If/Then and look up in same formula...must be an easier way

    Hi, I have the following situation. I am trying to look up months and currency conversion rates. I have a table which I am maintaining that looks like this. <tbody> 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 etc GBP 1.2 1.3 1.4 1.5 1.6 EUR 1.2 1.25 1.26 1.27 1.28 USD 1 1 1 1 1...
  12. ClintMc

    Hide rows of a named range based on user input

    Hey Guys & Gals -- Creating a template for Program Management and trying to add some VBA. New to VBA and what I thought would be straightforward is of course giving me a challenge. taskRange = all the potential rows in the chart, would like to hide based on user input (currently 1 column with...
  13. J

    Need Assistance with multi-condition "IF" formula

    This is the first time I have been unable to find the answer to a formula question on these boards before, so I figured I would finally post a question myself: First, some background - I work with multiple clients, who each submit cases to me. My boss recently asked me to begin tracking whether...
  14. J

    If Then - Fill? 1 List to 2?

    Hi all, I am looking to separate a list based off the value in one cell. I have a 'master' list that has all lots of items on it, and I want to be able to a number, or letter, in a cell off the side of the quantity/description/notes that will mirror the selection in a smaller list. Here is...
  15. J

    A challenge!

    Hello all! My name is Joe and I have a complex problem to solve that may prove a nice challenge for some of you excelperts! I have a document that I use to generate contracts by importing information from another program. But I would like it to do more. More on this Document Here...
  16. N

    Conditional Excel formula

    Hi all, I have a complicated Conditional Excel formula that needs improvement on: Sheet1 =has the MATCH INDEX information Sheet2 =is where I need the formula to be prepared/edited. Currently,in Shee2:E2, I have a formula that matches info from Sheet2:C2 to Sheet1:C and pulls the appropriate...
  17. A

    Value G is equal to E if G is greater than E

    Hi, I have column E and G both containing decimal values. I need the values in G to change to that of E only if they are 1.5 times bigger than E. Otherwise they stay as they are. Ifthen maybe? Gerry
  18. N

    How to use VBA for copy paste within a specified date/ header

    I've got many formulas listed like below, but want it so that a cell containing a date in another worksheet which matches with a header in a column, copies and pastes that column as values, but leaves the other un-matching date/headers as formulas instead of values. EX- The date on the "Import"...
  19. S

    If one cell contains text, return value of another cell, if no - do nothing

    Hello, I'm looking for a "1" in A and want return value from C-1 in B. If statement does not work for me, because =IF(A2=1;C1;"") changes previous row height noticeably, when the A2=/=1. How maintain former row height?
  20. J

    If Statment Based on Fault Of

    Morning, I'm trying to build an if then statement to count the occurances of the "Fault Of" when pertaining to quality problems. Below is my current formula that counts all occurances no matter what. =SUMPRODUCT(--ISNUMBER(MATCH('IR Detail'!$G$1:$G$10586,{"L1","Endfolds"},0)),--('IR...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top