ifthen

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

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

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

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

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

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

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

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

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

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?

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

Hi! I've been putting together a spreadsheet for awhile now and have been able to piece it together up until this point, my knowledge and understanding has run dry. We're running 2007, have a couple macros working already and creating a tool setup sheet for our CNC department and some tool...

I am trying to put an if statement before my index statement. The index statement works: =+INDEX($C$52:$C$125,MATCH(M31,$E$52:$E$125,0)) I want to put an if statement, so that if the my value in L3 can be matched to the array A52:A124, it will return the value from the index statement...

Hello I have an excel sheet that uses cursor mouse events to copy and paste fields from somewhere on the computer...about every 50th time or so for whatever reason it pastes one of the fields as FALSE...how can I error trap this to loop it back around...I've tried if statements like If Range...

I would like a formula that could generate the following outputs <tbody> AB AC AD AE AF AG AH AI AJ AK AL AM AN AO ex:1 2/1/14 2/8/14 2/15/14 2/22/14 3/1/14 3/8/14 3/15/14 3/22/14 3/29/14 4/1/14 4/8/14 ex:2 2/1/16 2/8/16 2/15/16 2/22/16 2/29/16 3/1/16 3/8/16 3/15/16 3/22/16 3/29/16...

Hi all, please help, Column C has rows of values. I want to populate column D as follows: IF Cell in column C is highlighted, then cell in column D = cell in column C, else leave the cell blank. Thank you.

Hello, I have the following formula below that sums finances by month. If the SUMRANGE (E:E) = zero, I'd like it to refer to cell E10 (alternative data). Could someone help me insert an IF E:E is zero, then E10? If the there is a number in E:E play out the formula. THANK YOU...

Hi!! I need a macro where I can highlight a column and change all of the 2 digit years to a 4 digit year (actually, some of the 2 digit years are only 1 digit, e.g. "9" instead of "09"). I have an if then statement that I can use in the column after it, but I'd rather change the actual numbers...

I know this can be done with a simple formula, but I have a lot of other macros going on with this worksheet and thousands of lines of data that changes every day so I would prefer a macro. Here is what I would like to happen in every single row: If Cell B2 contains "023001" or "023002", then...

First time posting here, but it really seems like some experts hang around, so I appreciate any help I can get. I have a list of numbers that I want to cross reference against another list (database column below), and return values in adjacent cells. Problem is that the query doesn't need to be...