formula =if()

Hey guys, I currently have a large list of data, but to simplify, here's a simple example: I currently wrote cell C5 as = J5 I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5 However, I want it to...

Hi, I am trying to write an If statement that ignores any value that is between -0.1 and 0.1. For instance, in the example below the row 2 delta is 0.1 and row 3 delta is -0.1 however I want to ignore this as it is spurious. In my formula it only delivers half of the desired result and ignores...

Hi I have a Cell B13 that is a DV list of labor types. I also have some named ranges in another sheet with the different labor costs in named ranges. I'm trying to use a 'IF' formular in cell I13 to show the various cost's depending on the labor type chosen in the DV list in B13 as shown...

I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...

Hi, This is probably a little low brow for you but I'm super desperate. I've tried using IF, AND & EXACT formula's to try and get a result but I'm getting nowhere. Bellow is the data set: Cell 'BO' has the formula -...

Good morning all! I need a formula that does the following: If one cell is negative and the other is positive return NA, but if both are positive or both are negative D4 (for example) I know it should be something along the below, but not sure how to write it to function properly. Thank you...

Hi everyone, I could use some help. I'm trying to draft a complex IF statement to break various customers into a green, yellow, orange, or red status. I have a column to specifically state this, which will use conditional formatting per color, so our leadership can more easily see which of...

Hello, I am trying to get excel to play a sound when data is entered, we scan into a database and sometimes the data does not go through correctly and need some way to notify the user that the data has been entered into the cell so that they may continue scanning. However I am running into an...

Hello guys , I need a validation , if in column A it is -100, column B must be -100 but if in the column A has any other value, column B can have any value. I have this formula but when entering for example the number 1 in the column A , and i put number 2 in column B I ger an error...

I have an advanced filter that runs on my Excel VBA application which is suppose to filter dates in the data base, I created the advance filter on the worksheet and it works fine except for when it comes to filtering dates this is the formula I'm using: =IF(C5="",">1","<=" &C5) start date...

Here is what I'm looking for: Column A Column B Column C 120,000 50,000 X 100,000 25,000 110,000 25.000 X 330,000 100,000 Grand Total I would like a formula that searches Column C for an "X" and then...

Dear Excel Gurus I would be grateful for your collective thoughts on how to add days in school terms. I am sure it will be an IF(AND) scenario but can't seem to figure it out. We have 3 terms at school, each 8 weeks long, therefore 56 days. Students achieve various goals within each of these...

Dear, I am looking for your assistance again. I have the below formula in column “L” of an Excel spreadsheet, which provides different results depending on various criteria, such as: 1) If Master DB, column “D” (HTS) is contained in SPI by HTS column “A”…a) If no, leave the cell...

Hi All, I have 2 formula that work individually which I can't seem to merge correctly. What I want to do is: If B3=IND & J3 (in tab RM IND)=YES then return the vlookup OR If B3=DOM & J3 (in tab RM DOM)=YES then return the vlookup These are the 2 individual codes that work...

Guys/Gals, I am trying to have the below code place a formula in Cells(lRow, 3) that contains variables. However, every time i try this it shows a #Name ? error. I have searched on this forum for additional help, but i can't get their solutions to work in my code. Can someone please show me the...

Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...

Hi all, I'm trying to write a formula that takes the dates from 3 separate columns compares them and then returns to me the most recent date. However, some of these columns occasionally contain NULL values. As of now my formula looks like the following: =IF(C:C>D:D,C:C, IF(D:D>E:E,D:D,E:E ))...

Hello I wrote a formula in order to trace the boundaries of some wind values. The boundaries are 0-90 / 91-180 / 181-270 / 271-360, and in return I want to get 0 for the first group, 1,2,3 for the second,third and fourth respectively. The formula is the next one...

I am trying to do a formula for: IF C5 is blank, then leave blank. If C5 has data, then subtract B5-C5. How do I do this? I have a picture, as well but don't know how to submit it on here.

Hi All, I am after some assistance with writing a formula. This is the data I have to work with: Sheet1- <tbody> A B C D E F CIS Key Document Created Date Client Name Planner Name Case ID Task when Document was Created 1111111 8/04/2018 Client 1 Planner 1 23565454 2222222...