=if

Hello everybody, and thanks in advance... I am currently trying to check, according to a list, up to 5 values (dispatched into 5 differents rows, concatenated from other values), and, using a "if" condition, having a "YES" if one of the values is present into my list, or "NO" if it's not. When...

I'm trying to build formulas to calculate the amount of window casing required for separate conditions. Window casing can be applied to a window as a picture frame ie, casing goes on all 4 sides of the window. In another condition, a windowsill is installed, and the casing is only applied to 3...

Hello, I am trying to calculate headcount needed based off of volume. There is a toggle used in the calculation that I can say I need per 100 units of volume, per 200, etc. but I only went up to the toggle value times 4. I need the formula to possibly support a much larger volume such as 40...

I have created a formula to look at cell f9 and depending on its value, I want to give it my own value. If its above 0 then it should always return with a '3'. If its under 0 then it should always return with a '0'. If the value is exactly 0 then it will return with a '1'. The issue I am having...

I am looking 2 formulas. Cell R5 contains data and cell R15 tells me if this data is true. I therefore want cell R16 to check if Cell R15 is True and therefore show the data that is contained within cell R12. If Cell R15 is false I don't want cell R16 to show anything. The 2nd...

Hi all, I need help creating an =IF formula as follows; If the value is equal to or greater then 0.00 = Win, 0.00 = Square, Lower = Loss and blank if nothing is entered. So far I have gotten up to the formula below; =IF((A1>0.00),"Win","Loss") So only the win and loss, would really appreciate...

I'm working on a homework assignment for my excel class, and I'm stuck on a certain question. I'm not sure what the correct approach would be to solving this problem. "Enter a function in cell M5 to calculate the total number of membership fees paid by members over the age of 25." The range of...

I am trying to set up a spreadsheet for work and am having a bit of trouble. I have created a drop down list, well two actually. These are in A2 & B2. From here I want cell C2 to display something from another worksheet depending on what it says in these two columns. The other worksheet will...

Hello, I am trying to see if there is some variation of the IF formula. What I am trying to accomplish is that IF C5 has a time of less than 3:00 then I would like to return a value of 'beginner'. If C5 has a time of less than 2:00 then 'average' and then less then 1:30 would return as...

Hello long time reader, 1st time poster:I have a spreadsheet which uses =F to give set responses i.e. Cell H35= =IF((G7-G35)=0,"No Issue",IF((G7-G35)>=1,"System/Paperwork do not Match",IF((G7-G35)<0,"System/Paperwork do not Match",))) I want a cell that will display "Issue identified" when...

Hi can anyone help. Is there an IF formula that if a certain condition is met in one cell then the entire row is copied to another specified Sheet. Please help

Hi can anyone help. Is there an IF formula that if a certain condition is met in one cell then the entire row is copied to another specified Sheet. Please help

I am an excel beginner so need help. I have 8 columns in Sheet 1 and hundreds of rows. In 'H' I have one of three different options 'Adam', 'Bob' and 'Chris'. I would like the entire row copied to Sheet 2 if Adam is chosen, entire row copied to Sheet 3 if Bob is chosen and Sheet 4 for Chris...

I'm trying to automatically populate 4 different tables with data from a single table based on the date in which the description occured. If its in Q1, then put data in Q1 table, etc. I appreciate any ideas you may have <TBODY> Date team description Q1</SPAN> 1/12-3/12</SPAN>...

I have a formula that looks on a different tab in the workbook, and if in the row the formula looks there is a "Y" then it retrieves the persons information and populates the cells in the tab with the formula. Right now the formula looks like this...

My question is a little different than other threads I have viewed. I want to hide an error value and keep the cell blank if there is a value of 0. The hide "0" option in the excel options does not work for this as a formula is pulling data from another formula. It seems easy, but I have not...

This is for a martial arts school. I am trying unsuccessfully to generate a page that will display estimated graduation year based on how many months a student will be in the program. I have tried all the lookup functions and not been able to get it to return a calue in the adjoining or next...

Hi Guys, The formula I am using returns #N/A. The formula is =INDEX(Amort!J12:J751,MATCH(D4&12,Amort!D12:D751&Amort!C12:C751,0)) Info: I have a monthly amort schedule in sheet 1 and need to return the end balance to sheet 2 if it matches the year in sheet 2. Sheet 1 looks like this. C...

Hi, I am new here so i hope I am in the right place.. I need some help with a bit of a complicated spreadsheet i have set up as a product selector / order form. http://www.filedropper.com/copyofvalves I have many cells referencing data from different worksheets but in one particular cell have...

Hi all, I am trying to create a formula using VLOOKUP where the returned value will be either the quantity found next to my array or if the VLOOKUP is unsuccessful, return a value of '0'. <TABLE style="WIDTH: 505pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=672...