if function

Hi All, Hopefully this is a simple fix for something that is driving me crazy. Basically I have 2 x cells. In the first I have a data validation list where I can choose something. The second cell displays some text depending on what was chosen in the first cell with a simple =IF function. When...

I would like to add weight of items which are delivered. That is if an item has along side a date then add that item to total else do not add that item. Please provide me formula. There will be 1000 + such rows and 10+ column . <tbody> Weight Date Weight Date Weight Date Weight Date Total 1...

I'm trying to tailor the IF command to put "SP" in a cell only if the referenced cell has FS in front of the number (i.e. FS101RR). FS will only be at the beginning of the entry, but isn't always there. What I've got isn't working which no doubt means it's not right. If there's not an FS in...

Hello everyone, Long story short, I’m trying to make a little training program to teach people at my job about scheduling. I’m trying to write a formula to show somehow how many people they’ll need at each station based on projected attendance. Let’s say O8 is where the attendance number is put...

Hello. I am looking for a formula that will accomplish: If cell A2 is greater than or equal to .03, then cell A3 is .03. if cell A2 is less than .03, equal that number that is below .03 Thank you in advance!

Using Excel 2016. Windows 7. I'm stumped and need help. A new real estate investment property was purchased that contains vacant and occupied units. There are two kinds of vacant units: Vacant Penthouse Units (PH) and Vacant Units (or all others that aren’t PH). There are a total of 14 Vacant...

Hi, I have a macro that works when Excel is opened. I need it to work when the active workbook name is "EXCEL_OMZET_SHEET1.XLS". Also this number 1 must be variable and can be 1 till 20. For each number it needs to trigger the function. I have used the following: If ActiveWorkbook.Name =...

I have 4 formulas that work independently. Two are similar to the other two in what they look for. I'm trying to put them all into one formula. How do I nest them so that if Excel finds #1 , it doesn't look for #2 , and if it finds #3 it doesn't look for #4 ? It would never find #1 and #3...

Hi all. I have the formula below =IF(E11="7.5",L6*K11,IF(E11="5.0",M6*K11,IF(E11="3.5",N6*K11))) In cell E11 i have the following in a drop down list, "7.5" "5.0" "3.5" I keep getting FALSE as my answer, if anyone could guide me in the right direction that's be...

Hello, I am trying to write a VLOOKUP formula that will work across different tabs. For example, if it does not find a specific number in columns A and B of Sheet1, it would search columns A and B in Sheet2, but it should only go to Sheet2 to if there is not match in Sheet1. I hope that...

Hello, I am asking for help with a question I encountered on the exam. The question states to divide two columns Ex: Column D by Column B. Then to use a nested If function with the Roundup function to round up to the nearest integer. Any help with this would be greatly appreciated. Thank you...

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

I'm trying to add an OR function to an IF function. I want to say if Q2 or Q3 <12 then A5 otherwise use A4. I can get it to recognize when I say just one-like Q2, but can't get it to recognize both Q2 and Q3. I've got =IF((OR(CSV!Q2<12)),.... Which works fine, but when I put...

I have two files. File 1.) A sheet that I am trying to fill in. Using a PO umber from this sheet to search others sheets. File 2.) A year long Calendar. Each Week has its own row. This file has a range from A7 - AB1767. What I am trying to do is use a PO Number from File 1. Look for it in...

Hello - Thanks for taking a look at this - I have been trying to get this right, and I keep on getting an error. I know it must be in the parenthesis syntax (at a minimum), but I am missing something...any help will be very much appreciated! This formula works fine...

If I have a product description in row B (which is validated against a list held in J2:J21), how can I write a formula that returns the corresponding product code in column A (validated in a list held in column K2:K21)? In other words, if somebody selects from the product description dropdown...

I am having a problem combining the IF function together with the Index function. This first two formulas listed below work, but when I take the two ideas and put them together to create the third function, I get a #Value error. Can anyone explain why? I am using Control+Shift+Enter on all of...

Hi, Perhaps this has a simple explanation, I hope.... I'm trying to use the IF function to calculate some standard corrections. I'm using the following formula: =IF(AC9<1, Q9*AC9, Q9) Q9 = 53.00 AC9 = 0.74 The idea is that AC9 is a ratio, so if it is below 1 I want excel to...

I am creating a running inventory sheet. In most of the cells, there will be a serial number that I need to count as -1 from inventory count. In stock will be calculated separately, I need to continually subtract from In Stock to get my Available total. What formula should I use? In example...

Hi Folks, Apologies if this is an idiot question but I’m struggling with a spreadsheet. Some context: I have a staff schedule/rota for a retail store in excel. I have a second spreadsheet that calculates wages. I would like the wages spreadsheet to be populated by the schedule/rota. We’re...