if function

Hello, I am trying to write an IF function with two conditions, SUM(C2+D2+E2+G2)>0 and SUM(B2+F2+H2+I2+J2+K2+L2)=0. So only if certain fields are filled in and others are 0 I want it to return a value. I have this so far but it does not seem to work properly =IF(AND(SUM(C2+D2+E2+G2)>0)...

I am creating documents that are ongoing data entry throughout the month but I want to be able to insert a TODAY() function based on text input into a certain cell (simply, once someone starts typing, that day's date gets input in the date column). So far so good, my IF function for inserting...

Hi guys. I've been trying to figure this out but haven't been able to. Here's my equation now =IF('URD Take Off'!$D1='URD Summary'!$B:$B,VLOOKUP('URD Take Off'!$A2,'URD Summary'!$B$5:$M$2462,10,FALSE),0) Essentially I am trying to say if the vendor name (cell d1) exists in row B in my reference...

I have a lot of lines in a data set that look something like this: 006MSP95228184 006ATL95228195 006ORD95485250 I don't care about anything but the 95228184, so I used the following function to rid myself of it: =IF(LEFT(A1,3)="006",RIGHT(A1,8),"") RESULT: 95228184 - excellent right...

I am trying to create a function that will recognize data beginning with "006" If it finds data beginning with "006" then remove all but the last 8 characters I don't know why I am having such a hard time with this one. Something like: =IF(LEFT(A1,3)="006"(RIGHT,A1,LEN(A1)-8) Thank you in...

Hello, I am trying to use the IF function to perform a calculation. I will try to outline the scenario below. A sheet called 'Outputs' has monthly data, running from Sep-17 in cell T36 to Aug-27 in cell EI36. Another sheet called 'Analysis', in which the formula is going, has the same monthly...

Hi, I was wondering if somebody could help. I'm trying to identify apply an embedded IF formula to identify whether a date in a one cell is before or after another cell. The two date cells my formula is referring to are loss date and renewal date. The IF function reads: if the loss date is...

Okay, I am stumped (hence why I'm posting here). No matter what I do, I cannot get this formula to work. Here is the current bane of my existence: =IF(J7 < 25%, "Text 1"), IF(J7>25%, "Text 2"), IF(J7>50%, "Text 3"), IF(J7>75%, "Text 4"), IF(J7>= 99%,"Text 5") I have no idea what I'm doing...

Hey! I have 3 cells, 2 are with names, they are not sorted, as they are extracted from two different webpages. Basically eg. Cell 1 (full namem, random order): Masahiko Inoha Cell 2 (partial name, usually the following): M. Inoha (in some cases however full names) Cell 3 (extracted web code...

Hi everyone! I need your help with the following issue. I need a formula that would insert into a cell the last value from the first column depending on the wording in the second column. In other words, I need a formula that would insert into one cell the value of 40 (which is the last value...

I'm trying to make a table that determines the price of a track depending on the length of the track and the track type. What I want is to have a table that does the following: Column A= Track Type (Ceiling fix and Face fix) Column B = Track Length Column C = Track Price If track type...

i need to copy values from a table when 2 other conditions are met. Table 1 <tbody> ID COUNTRY TYPE Details AA AZ READ This is used for reading in AZ AB UK Write This is used for writing in UK CD US EDIT This is used for editing in US AA AZ Write This is used for writing in AZ...

Hello, I would like a formula that returns an array, that satisfies the is statement Column A = 2 - BUT I would like to skip the blanks ={N(OFFSET($B$1:$B$100,SMALL(IF($A$1:$A$100=2,ROW($B$1:$B$100)),ROW(INDIRECT("1:"&COUNTIF($B$1:$B$100,2)))),0))} This gives me almost what I want, but it...

Ive got some code that checks if a cell is a number if it is then it runs a msgbox if its text or empty then displays a msgbox and halts. I'm struggling to work out how i can get it to check other cells to display different msgboxs? As in check cell C5 is not empty else display msg box...

Hey, i am a student at the university of utrecht and i have calculated the net present value of several projects successfully and have been asked to do so again. I realised that i keep rebuilding the excel sheet i use to do that for one reason, i cant find a way to add the initial investment...

Cell A1 has Date Started, Cell A2 has Date Completed I want an if function that puts 1 in A3 when someone enters a date in cell a1 and cell a2. Any help is greatly appreciated.

Hello all, I have a lot of data with three input columns (End date, Break Date, Rent review) and I can't work out a formula for the output column (LEASE EVENT). In each row, i want to know the closest date FROM today date, with the corresponding column heading to end up in the output column...

Hi, Trying to add dates depending on if meets criteria. If the date is less than 7 days then I want the function to go to the next Thursday before. If it is more than 7 days, then it can leave on that Thursday date. Here's the equation I have...

for example if cell C2 is equal to cell F2 then C2 font colour should change to green, if it not equal then C2 should change font colour to red I realise this is simple, but I am a beginner with these functions. I am using Excel for Mac 2011. much appreciated. NL