nest

Hello board members! I have this formula: =IF(AND(E18="Yes",OR(A8="ABCD",A8="EFGH")),"-1.48% Fee","") It need another condition: =<date(2019,5,1)........"-1.48% fee","") IF(D16<<date(2019,5,1)........"-1.48% fee","")="" <="" date(2019,5,1)........"-1.48%="">DATE(2019,5,1)........"-1.48%...

I have a range of data for example: 1 1 1 1 2 2 2 3 3 2 2 2 1 and i want to have a total of how many times the number has gone up and how many it has gone down. So in the above example it would be Up=2 and Down =2. The number range is only 1->4 I have tried: =IF(AND(A1="1", A2="2"),"1","")...

Good morning, I hope someone will be able to assist me, I am creating a worksheet that looks for a value ( For example Servon ) and second value ( For example EE Estonia ), based on this it would pull data from the relevant worksheet Servon EX EE. I currently have the formula laid as below...

So i have a nested formula that i would like to shorten or to convert to VBA General info: - I have a sheet containing part numbers in column A: sheet name "Unknown" - I have 3 sheets containing information i need each with different part numbers. sheet names: 1,2,3 One of the 3 sheets...

I've been given a particularly diabolical challenge, and for the life of me, I cannot make it work. The challenge is to execute within a single cell a formula that will calculate "EAC: equivalent annual cost" within a single cell. There are two distinct steps in the calculation; first, one...

Hello. Can anybody tell me how to write a formula that says "If there is text in either A1,B1, or C1, then say "text", otherwise say "no" ... thanks

I have in column B the following formula IF(F2>8997543,(LEFT(H2,(FIND("/",H2)-1))),(LEFT(H2,(FIND("-",H2)-1)))) This returns a unique reference which I then want to run a vlookup off in column C =VLOOKUP(B2,lookup!J:K,2,FALSE) I was going to nest the lookup but even separate I'm getting #NA...

I need to nest a few IF statements into a VLOOKUP and I am having issue figuring out how to get this right. I have looked through a number of related post but haven't found one describing my situation. This is my current formula =IFERROR(VLOOKUP(A7,ElliotsPricingUpdate,6,0),"") The table...

Is it possible to nest SUBSTITUTE within an IF formula? I have a column that has a range of numbers in it that I want to combine in a TEXTJOIN string. However IF the number is a decimal, I need to substitute the decimal with an underscore. i.e. instead of 6.875 it needs to be 6_875. I'm not...

Since you are all so wonderful at helping, I have another question. I'm trying to nest IF, AND, and OR together. I want to tell it IF Q2<12, OR R2<12 AND B2=V are TRUE, then A5, if false then A4. My current working formula is however it doesn't have the AND function in it because I'm not sure...

All, I have this equation =SUM(IF(ISNUMBER(B4:B200),IF(MONTH(B4:B200)=MONTH(R3),--((C4:C200)))) B is a list of dates R3 is a drop down of months C4 is data or numbers What I need to do is for February, I need to sum feb then sum Jan and then I need to do this math (What I want = ((Feb+Jan)-Jan)...

People Looking for a bit of general guidance here. In Col A I've got several thousand rows of data in the form of football team names. There are about 250 individual teams/strings in total. They all appear in Col A many times. I need to match each occurrence with their nationality in Col B...

Hi all, i'd like to know if it's possible to nest a private sub in another private sub. I don't want one of the sub to be public or something. The code would looks something like this: Sub main_sub() Call sub_parent End Sub --------------------- Private Sub sub_parent() Call sub_child...

Hi! Here's a link to my data: https://app.box.com/MyQuestion My Question: In the file that I'm sharing (link above), my data is arranged like this: <colgroup><col><col><col span="5"></colgroup><tbody> A B C D E F R1 Customer 39222 33525 34035 34136 34712 R2 5440226048 1 2 3 4 7 R3...

Hey guys and gals, First time posting... I don't even know if this is possible but I know I'm not the man to figure it out. I want to search a single cell (A1) for three different keywords and return a corresponding value for each keyword found using nested IF functions. This is what I have...

Hello, I wrote a code snippet that checks a cell for a number value (any number value), and if it finds it the header of that cell appears in another cell. What I want to do is nest (?) additional cell checks so that the final cell has all of the headers. =IF(ISNUMBER(C3),C2&",","NO") C3...