fail

I would really appreciate help with the following formula as I just can't get it to work. For each failure during a month I get charged 10 If I fail three months in a row I get charged and extra 50%, so 15 per failure. If I fail again in the next month I get an additional 50% on top, so it's...

Hi I want to highlight "pass" in result column to different color but not only pass but student name that correspond to that pass For example, cell F2 = pass should be highlighted to different color and also Mary1 as well (like reverse lookup) I can use conditional formatting to highlight pass...

Hi all. Wonder if anyone can help. How do you put this formula into a conditional formatting formula based on if the answer is “Pass” the cell is green, “Inter” the cell is yellow and fail it’s red. PASS =IF(SUM(D3:$H3)<=$C3 INTER =IF(AND(SUM(D3:$H3)>$C3,SUM(E3:$H3)<$C3) FAIL = any other...

I have 100,000 records in a table (data) in sheet 1 as per below based on "Success" or "Fail" Table (data) Event Result MB65 Success B65 (AI) Success MF6.1.1.1.3 Fail MF6.1.1.1.3.1 Fail MF6.1.1.1 Fail I need to colour a row based on another table (_MF6) which...

Need some help please I have a tab with quite a few columns and need totals Col A = Staff Names Col B = Course Name Col C = whether they have Pass or Fail Col D = uk or non uk i wish to creat a new tab and count how many staff have pass or fail and if they sit in Uk or non uk New tab with...

I'm looking to see if there's a formula that solves the problem below. In column A, I have a series of application I.D.s; some can appear once, some twice, some three times etc...there is no way of knowing in advance how many times an application I.D. will appear. In column B, I have a...

Hi excel guru's just a newbie here, so I just need someone who can help me with a formula. Data is from column A to J, so what I need is like to appear a formula in J when 3 condition met. A=employee Id, start on row 3 and so forth, H= Date where employee process a case, I= marking if the...

Good morning! I am trying to write a If/Then formula which returns one of two statements based upon the input in an series of cells. Example: =IF(H29:K38="X","Fail","Pass") If an "X" appears in H29 - K38, I was "Fail" to appear in a cell, if "X" does not appear I want "Pass" to appear...

I have an inventory of 550 emergency exit lights that must be tested every month. I'm finding my testers are not actually testing the lights but just checking them off on a printed spreadsheet. I want to install barcode stickers on the lights so they have to go to each light to verify...

Hi all, having issues with excel VBA and any input for this will be much appreciated. i have searched existing threads and not able to find the fix for this issue. here are the issues : 1 After saving the model, the macro run would fail, with error message below: Run-time error...

HI :-) I've got a spread sheet with text data. I need a formula to search for any instances of a text string "2017, 2018 or 2019" & get a FAIL output in the adjacent column. I get success with the below formula but i just cant get / re work it to search for three different words, e.g. 2017...

Hi guys, Sorry to be a bother. I hope you can help. I have 7 columns, I want to apply a formula in the first column to return the value "Pass" ONLY if the next 6 columns are either all "Pass" or blank. If there is any one column that has the value "Fail", I want the first column to return the...

Hi All, I want to count the total number of Pass and Fail based on Column 1 (Originating) site. For. Eg., If I select US, I should get 3 pass and 1 Fails, and if I select UK I should get 1 pass and 1 fails. Can someone please help? <tbody> Originating Site Description US Pass US Pass UK...

I have some data that has the word "pass" or "fail" in one column, and a date in the one next to it. I am trying to use COUNTIF to count how many times a pass or fail occurred within each month. I have tried both of the below formulas: =COUNTIF(A1:A5,"Pass"),(MONTH(B1:B5)=F13) (F13 is...

Hello I need assistance with coming up with a formula for spreadsheet 2 column 2. I have a list of all PO in spreadsheet 1 and need to Pass or Fail based on the status from spreadsheet 1. If it contains a no or maybe then fail. this is a s implied version. <tbody> Spreadsheet 1 </tbody>...

SUM(COUNTIF($D4:$M4,"*"&$AC$1&"*"),COUNTIF($D4:$M4,"*"&$AD$1&"*"),COUNTIF($D4:$M4,"*"&$AE$1&"*"),COUNTIF($D4:$M4,"*"&$AF$1&"*"),COUNTIF($D4:$M4,"*"&$AG$1&"*"),COUNTIF($D4:$M4,"*"&$AH$1&"*"),COUNTIF($D4:$M4,"*"&$AI$1&"*"),COUNTIF($D4:$M4,"*"&$AJ$1&"*")) I have the above formula copied down 3,000...

Anyone can help on how to calculate Column D: <tbody> A B C D 13:00 14:00 01:00 Failed 13:00 13:00 00:30 Passed </tbody> In column A and B, and C, i used MOD, format cells custom 00\:00 in subtracting time. For column D, I tried this formula IF(C1>1,"PASS","FAIL") but it does not give...

Okay, so here's what I'm doing. I'm teaching a class that requires essays to be submitted. The first one, since it was due on class 2, I am doing Pass/Fail - if you turned it in you pass, if you didn't you fail. I've created a monster spreadsheet to do my tracking for me. What I want is to...

I need help building a function that.... If the number starts with: 06, 10, 63, 71, 91 That row FAILS! Example: (Wont let me upload photo) ​ <thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"> NUMBERS: First Two Characters: PASS/FAIL: </thead><tbody...

Hello All, I have a data set where an Entry is graded Pass/Fail on a series of inspection points. If any of the inspection points "Fail", the Entry is considered a fail. I'm looking to write a formula that reviews each line and counts each Entry that is a Pass. I have been able to accomplish...