if and and

Hello, Context; I'm very much an amateur when it comes to excel but managed to put the below 2 formulas together from a few forums but its causing my s/s to run incredibly slow. The s/s is also web linked to an intranet form which could be causing some of the delay also. The form is a...

I have a formula to try and make a calculation of profit or loss, but cannot seem to get it to function correctly C is the number of runners R is the price T is the finish position Here is the formula =IF(OR(AND(C2<=3,R2<=20,T2>1),-80, AND(C2>=4,C2<=7,R2<=20,T2>2),-80...

Hi, Please help.. Need a formula. I couldnt make the string?:confused::confused: i NEED FORMULA ON "H" that will output the following scenario? many thanks <tbody> A B C D (TOTAL b &c) E F G H 1 0 0 0 0 0 0 0 NO DEMAND 2 0 10 10 20 20 0 20 In Process 3 15 0 0 0 15 0 15 Need to Order...

Hello Column A Column B <tbody> 1/1/2016 12:00:00 am yes 1/1/2016 3:00:00 am yes 1/1/2016 6:00:00 am yes 1/1/2016 9:00:00 am yes 1/1/2016 12:00:00 pm yes 1/1/2016 3:00:00 pm yes 1/1/2016...

Hi, A quick one. I have Shopify, and get the following raw data: customer ID, date of purchase and amount (€) I would like to perform a cohort analysis <colgroup><col><col><col><col></colgroup><tbody> Client ID Date Amount Date of 1st purchase 68 Jan-15 € 7,979...

I want a formula that If sum of H1 & I1 less than or equal to 2 and if I1 is greater than 0 then H1*1000+I1*500 else H1*1000+I1*500

The goal is to use a formula to get a particular e_c value in a cell and a particular e_a value in a another cell given the three logical tests which are E_a (either E_a < 0.5E_C or E_a > 0.5E_C), Class (1,2 or 3) and Repair Lifetime (Any Value rounded up to 2, 10 or 20 years). I understand that...

In my sheet I want that IF H5 of Backend sheet will be matched with some text of D5 then it will search in a range of Data sheet. I am trying for code that =VLOOKUP(H5,IF(D5="CAR", ???? then it should search a range from the DATA sheet for the H5 if the D5 matches with text "CAR". what...

I am attempting to create an IF AND statement for the following scenario: Sorry I can't get a screenshot in the Mr. Excel tool is blocked here. K L M N O 02|...

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

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

Using Excel 2001 on Windows XP Pro, I have three IF formulas that I want to combine into one. <TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD...

I want to only return a correlation number if there are numbers in both B245 and KA 245. I assume I would use an IF and an AND argument, but can't figure it out. This is what I have so far. =IF(ISNUMBER(B245),CORREL(B245:B256,$KA$245:$KA$256),"X")