if/or

Can VLOOKUP be used to satisfy one "values_if_True" components of an "If/OR" formula? I'm wondering because I'm trying to use VLOOKUP to work if one or another of two conditions is met. However, the following formula works only if: CONDITION 1 and CONDITION 2 are met CONDITION 1 is met and...

Below is a diagram of sheet 1 ( reference sheet) and sheet 2, I would like to have info on sheet 2 to only show if column H from sheet 1 is AA, not sure is a vlookup or if/or formula is best, any help much appreciated Sheet 1 . A B C E...

Hi I assume I need a Count and/or Sum formula if the letter "S" is found in "I4" and also "A" is found in "F4" (both found not if/or) then use value found in "AP4" Any help would be great Stephen

Hello, I am trying to figure out if this certain excel function is at all possible. Say we have column A with values ranging from 1.00 to 999.99 unordered. Then we have column F with text either "In Process" or "Completed". Is there any way to take a range of those values, say 1.00 to 399.99...

Hi, I’ve been struggling to put a formula in to Excel. For instance in Cell L4 I want to say the below. Cell L4 = -26% so I want the cell to say Poor. Cell L5 = 15% so I want it to say OK etc. Any help greatly appreciated. If the accuracy is between 0% and 5% or between 0% and -5% then...

Hi, I have a worksheet with a series of numbers like so: A1 - $36.10 B1 - $1,835.25 A2 - B2 - $1,321.25 A3 - B3 - I would like to divide column A by column B, and either get a number (not 0) or have the cell be blank. I've tried =if(or(iserror(A1/B1),B1=0),"",A1/B1)...

Please help What I am looking for is that I have a sheet that has grades. I have it in 4 sections for quarterly. I am trying to do is in B1 is reference 4 different cells and determine 4 different results according to the data is these cells and copy from another 4 cells depending on the...

I have a spreadsheet with six columns and 80,000 thousand rows. Each row is a record. There are three columns "participated, lead, volunteered". We need a formula that will tell me that total number of records that did ONE of the Three things. So I can't simply sum count if functions...

Hi all, I am having trouble with one part of a piece of code where I want to say if the value in a certain cell is equal to one of multiple values and I think there must be a better way to do it. Right now I have a ridiculous number of or statements and it looks something like this...