=if

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

I'm having trouble drawing an area chart that ends sharply at a specifided value rather than drawing a diagonal line down to zero. Let me explain I watched an Excellsfun youtube tutorial that used the IF statement to chart a subset of normal curve data as the second series in an area chart...