fail

Hi Any help greatly appreciated before my head hits the desk.. I need a formula that says IF L3 is greater than 1 but less than D4, "ADVISORY" but if L3 is greater than D4, "FAIL". Additionally, if L3 is less than D4 but d2 is greater than f2, "ADVISORY" otherwise "PASS" I hope that makes...

Hi, I've been working on some VBA in MS Word to that requires access to information in an Excel workbook. I'm having trouble when Excel is closed before my procedure is called. I'd like to avoid dependence on the user opening Excel before the application is used; consequently, Excel may or may...

Afternoon I hope some kind some may be able to help me. I have a worksheet where I would like to be able to calculate an anecdotal 'Result' against some date based fields. I.e. 'Response SLA' and 'Actual Response' - I would like to be able to compare these 2 dates and if the Actual SLA...

Hi All Can someone please help me. in below table Column D is data validated only to have "won" or "fail" , I need a vlookup formula in column D which will look status of column A in column C and if it should result if it is Won or failed, if there is any other value other than won or fail it...

Good day. I need a VBA for the following. We have a sheet with cells in Column N where the word "Fail" appears if the criteria was not met, based on an IF formula. I need the row to copy and paste to a different workbook in the next available row, if the word Fail appears in the cell in column...

I am looking for a formula to do the following: Cell a1 = -0.047 Cell b1 = ±0.060 I want cell c1 to show a "PASS" if cell a1 is less than cell b1 show a "FAIL" greater than b1 Any ideas would be helpful. Thanks

I've been using this line of code for weeks with no problems. Now all of a sudden, it wants to fail. I've verified that the file path is correct, and that the file exists. I've tried adding DoEvents before and after this line, but it continues to fail. All I get is the Method Open of Objects...

When I paste something int my workbook, Excel 2020 brings up a little white square with (Ctrl) and a drop down offering "use Text Import Wizard". How can i tell it NOT to do that please? Also the only way I can find to get rid of it is to remove what you pasted. Words fail me!

Good day, I have a formula that determines if a value is a "pass" or "fail", based two other values. The following is what I have; =IF((AND(C2>=E2, C2<=F2)), "Pass", "Fail") It works great, however, my question is how to leave the cell blank if there is no value inputted into the cell...

I was wondering if someone can tell me if Excel has a way to pull a user name from AD using a text box input and an MSGBOX output and if so what the code may be to attempt this? I have attempted it but each time I try to do so I fail and would greatly appreciate if anyone may know the code for...

Hi guys. Need some help with an If Statement if you please. =IF(W7="Fail",IF(W8="Pass","A",IF(W7="Fail",IF(W8="Fail","R",IF(W8="",IF(W7="Pass","G")))))) W7 and W8 are combo boxes (Blank, Pass, Fail) By selecting W7 Fail and W8 Pass, it returns A By selecting W7 Fail and W8 Fail, it returns R...

Hi Everyone, I have spent way to much time trying to connect everything into one formula, to the point where i am not sure if it can be done. Hopefully my explanation below is not too confusing. I need to make the following work: If cell C2 contains Apple,Orange or pear and cell D2 is less...

Hi, I have a data in column A as ASR903/I-AP-VKPM-ENB-0178/VKPMGLNMPAR001/172.16.98.137/PSU fail 2/10 --> a1 ASR903//I-MH-PNJI-ENB-0070//PNJISNGLPAR002//172.16.98.38//p0 unknown --> a2 ASR-903// I-WB-ASSL-ENB-0077 *ASSLNCPRPAR001/172.16.58.119//P1 fail --> a3...

Long time lurker and first time poster! Hi all I have a spreadsheet of names and the data fields pass and fails (1 or blanks). I need a formula or Conditional formatting that if the fail is 1 to highlight the cell above. I'm trying to think of the best way to achieve this goal? Thanks

Given a list of 20 numbers between 65 and 100. Anything less than 70 = Fail (F); between 70 - 93 = Pass (P); and anything over 93 = exceed (E). What is a formula that I can use to derive results.

I'm struggling and need help to do the following: I'm pulling text, which can vary depending on the original result, from one sheet to another. This will show in cells E5:E24 and F5:F24 (not merged). For example, after one review E5 could say "Building" and F5 could say "Post 01.06.2004"...

Hi, hopefully someone can help with my problem as per the title: I have 2 working formulas I want to combine with a bit of adjusting: This formula works (Formula 1) =IF(AND('Data Area'!BH2="N/A",'Data Area'!AU2="DS"),"Pass","Fail - POMI cannot be N/A") So does this one: (Formula 2)...

Hi, hopefully someone can help with my problem as per the title: I have 2 working formulas I want to combine with a bit of adjusting: This formula works (Formula 1) =IF(AND('Data Area'!BH2="N/A",'Data Area'!AU2="DS"),"Pass","Fail - POMI cannot be N/A") So does this one: (Formula 2)...

I am working on a spreadsheet of mostly pass or fail that has comments spaced throughout it. The person who made the spreadsheet used this formula to achieve a pass or fail percentage: =COUNTIF(M18:AX18,"Pass")/COUNTA(M18:AX18) But it counts the columns that have comments as a fail so it...

Hi I've used this forum as a knowledge base for a while now however this is my first post so I'll try to include enough information. I've created a spreadsheet that reports weekly information for my company on tab#1 whereupon the data input from the end of each week is entered on tab#2 and all...