if and or

Hi! I'm trying to clean a dataset and only retain families with at least parent at home. I started going through it manually but it took 7-8 hours to do 3,000 entries and I have 30,000 entries left to do! There must be an easier way so I figured I'd add the criteria here and maybe someone...

I can complete an AND fx no problem, but when i combine and AND & OR fx, I am stumped. This is probably a simple fix, but I could use some help from an fx expert. I am trying to write a fx where: If the number in cell A1 is greater than 3 OR less than negative 3 (so nothing from -2.5 thru...

Hi all, For the life of me I cannot figure out why this isn't working: With Worksheets("Service Order Themes") t = 0 For f = 2 To themeLastRow If Worksheets("Service Order Themes").Range("A" & f).Value = "From/To" And _ Worksheets("Service Order Themes").Range("H" & f).Value = "Open" Or _...

Background: I'm working on a constructed language, and wanting to use an Excel formula to check that the rules are being followed as words are created. So the first rule I'm trying to check is that the first letter of a word, depending on the type of word (Noun, Verb, Adjective, Adverb, and...

I want a formula that will read multiple columns. IF the column ISBLANK I want it to go to the next column on the list. IF that column has a value then, move to the next column till all are read. At the end of the process I want it to READ all columns and return the minimum value (which would...

Hello to all, I would like to convert data from a numerical value or values to a text value or string. Column A are the X axis numbers, Column B is Y axis values and column C are the Z axis values. Based on the value I want to declare it as the Axis(s). The values in all columns are...

Hi, I am trying the following formula: =IF(AND(J6="Yes",OR(B6<>"Nigeria",B6<>"Togo")),30%,0) In order to do the following: If J6 = "Yes" and B6 does not equal "Nigeria" or "Togo" then return 30%, otherwise 0. But if I test it by having J6 as "Yes" and insert either "Nigeria" or "Togo" into...

=SMALL(IF(X_LANE=D2,X_TIME),1) CTRL+SHIFT+ENTER Is working fine for me, returning the smallest value in my array "X_TIME" when "X_LANE" equals D2. However, I want to try this: =SMALL(IF(OR(X_LANE=D2,X_LANE=C2),X_TIME),1) But excel is returning the smallest value in my array "X_TIME"...

Hello All, I am new to this site in hopes of a little help. Here's the quick scenario: I have 2 columns that I would like to compare. They start at F4 and G4 respectively. Here's what I am trying to achieve: IF F4>0, G4>0 display NO PITCH F4=0, G4>0 display GAS F4>0, G4=0 display ELECTRIC...

Hello Everybody, Good evening. My Columns are as follows: A1-Criminal Name, B1-Crime, C1-Age, D1-Ratings, E1-Punishment In the punishment column one will get 22 years life imprisonment if he fulfills the following conditions. 1. He must have done Rape OR Murder...

Hi Guys, I have inserted the following formula into Z3 cell: =IF(AND(ISNA(V3),ISNA(W3)),"NA",IF(OR(TRIM((U3)*1)=TRIM((V3)*1),TRIM((U3)*1)=TRIM((W3)*1)),"OK","ERROR")) The purpose of this formula is to compare values between U3 and V3 and U3 and W3. Usually V and W are mutually exclusive, so...

Can some one help me how to write the formula For If J3= RH170 AND J4= Backhoe AND J5=Electric Display no1 in D6 OR IF J3=RH170 AND J4=Backhoe AND J5=engine Display no2 in D6