conditions

Hi , I know how to use the Simple IF and IFS formula. I am trying to combine two , three IF formulas based on a set criteria but there is an error in my formula. Could you please help me. Thank you What I would like my formula to do is search for two conditions in two adjacent cells, if...

I am trying to write an IF function based on 3 conditions. It will test the following (A3+B3)*.1 = answer. If the answer is less than 150 then display 150. If the answer is greater than 400 then display 400. If the answer is between 150 and 400 then display answer. I have tried a nested IF...

Hi all I have 4 columns of data in column A I have some random values and mostly blanks. in column B I have a calculation which looks at column A and if a value appears there it discards the values above it and takes the new value from column A. In column C I have a formula =...

I'd like to sort my data (A1:D10 with headers) by values in column B. I want to only show entries that do not contain 123 or ABC or 456 or DEF in column B (entries can be at the start, middle or end therefore I'm guessing I'd need to use * wildcards). Autofilter seems to limited to two...

I have three conditions in one cell... Cells C3, D3, E3, can have blanks, zeros or numbers. Here is the conditions... Sum(C3:E3) are all blanks, leave cell empty Sum(C3:E3) >0 = return sum Sum(C3:E3) =0 = return a zero How would I write that in a single formula?

Hello, I am trying to write a formula which encompasses all the following conditions, and am having trouble figuring out how to put them all into one formula with And/Or statements. Here's the criteria: If B2 = Full Time and F2 < 172 Or if B2 = Part Time and F2 > 160 Or if B2 = seasonal...

Good day to all. I have a table with multiple conditions with specific amounts if conditions are met, but Im stymied on how to create the IF and/or formula since the conditions have min/max ranges. Hoping for some help :( Thanks a lot! Sample table below: <style type="text/css"><!--td {border...

How to create a drop down list with conditions as follows: IF B1= 1981, C1 = <colgroup><col></colgroup><tbody> 800-15-920-18-1118-21-1265 660-40-1100-50-1600 550-25-625-30-745-35-780-40-1220-50-1470 500-20-540-25-640-30-820-40-920 440-20-560-25-785-30-875-35-1050-40-1170...

Hi guys, Me again! Trying to conditional format the whole sheet so that whatever date falls past today, then it will red out, however it conditions all blanks files to do this also, so everything in the file gets filled in :( Would appreciate the help! Thanks Will

I know this is technically not an Excel question, but there are a lot of people here with better math skills than mine, so I hope this is OK. I would like to find a family of functions, f(x,m), that meets these conditions: Maps the domain (0,10) onto the same range and is continuous over that...

I am editing a report in excel. Is there a simple way that I can set multiple conditions for a column without having to continuously search the entire workbook for information? Thanks in advance.

Hi All I have a spreadsheet which looks like below: Sheet1: <tbody> A B C D E PROJECT START DATE 1 END DATE 1 START DATE 2 END DATE 2 A 07/01/2018 06/04/2018 01/06/2018 01/09/2018 B 04/04/2018 05/07/2018 C 04/04/2018 07/07/2018 D 10/10/2018 02/02/2019 E 01/01/2018...

Hello, I have 3 conditions: If a=no, b=no, c=yes then I want d to show "" If a=no, b=no, c=no, then I want d to show "inop" If a=no, b=no, c="", then I want d to show "inop" If can write IF And statement for the first 2 conditions but I am having problems try to add the last condition to the...

Hi all I have over 15 macros only run with conditions that: If sheets(A).range(A2)<>"" then call macrox If sheets(B).range(A2)<>"" then call macroy ........... If sheets(C).range(A2)<>"" then call macroz How can I get all in one macro? thanks./.

Good afternoon (or other time of the day, depending on where you are) I have a spreadsheet with a macro in it that gets called with the following condition Set target = Range("E2") If target.Value = "TRUE" Call SubmitRequest02 End If So what I want to do is Call SubmitRequest02 only with...

I have to do an average of data and it must satisfy following conditions: The columns are non-continuous. the values in the columns are 0,1,2 and a blank _____. while averaging it should only consider cells which have values 1 and 2. if all the cells are blank then the average value must...

I copied most of the code below from somewhere and modified it a little and it basically works how i wanted except for some conditions that I wanted to add :( The original code with slight amendment and which works is below: Option ExplicitSub INDO() Dim arr As Variant Dim wsO As...

Hi I want do check student marks and based on the value I will make excel to type a,b,c,d,f. If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier...

Goog Day, On cell C41 I want to put a formula which will calculate the total sum with the conditions below. I've created a table from B6:D40 There will be numbers from B6:B40 and C6:D40 will have the letter info as X My target is to get the total of those numbers.But if there is no info on...

Hi all I have two sheet(A) and sheets(B), now I want to compare with three conditions and color row(j) in sheet(B) if wrong Conditions that: 1. Mid(sheet(A).row(i) = Mid(sheet(B).row(j)= "201808-5600" 2. Sheet(A).row(i,2) = "1011" 3. Sheet(A).row(i,3).value/1000 = Sheet(B).row(j,2).value How...