if statement calculations

Hi Experts of Mr Excel.com, Please let me know if I'm not making sense. Heres a sample. Action 1 - 4 will result in either a "Pass" or "Fail" Overall Outcome = Fail (If 70% or below, or if Action 3 results in a Fail) Overall Outcome = Pass (if above 70%, and if Action 3 results in a Pass)...

I have a formula that uses an if statement to compare if 2 columns are equal. I am getting true for some and false for others, and after I make both cells equal in their mathematical formula, I am still getting false. I checked the values, and they are equal. I also read online, that it could be...

I am not sure if that exactly what I am trying to do but ultimately I am trying to make an end of day sheet. It would only have 3 worksheets. The cover would be the printable page split into 3 payment methods credit, paypay and store credit. I would collect all this information form the...

Does anyone have the solution to the sumifs problem i have? =SUMIFS('Import Infomation'!$F:$F,'Import Infomation'!$E:$E,("*"&February!$A3&"*"),'Import Infomation'!$B:$B,B$2) 'Import Infomation'!$F:$F is my quantity 'Import Infomation'!$E:$E is the range for the product code...

I am stumped with this. I have due dates for my assignments. I would like to apply a 1% penalty for every day they are late. The formula I have been trying to get working is: =IF(TODAY()>Report!D12,F8-((TODAY()-Report!D12)-((WORKDAY(Report!D12,(TODAY()-Report!D12)))-TODAY()))*0.01)...

Hello, I'm having trouble with calculating a formula. Refer to the numbers below for the questions. 1. I want to calculate if the PIR price equals the Invoice price to change the PO price to the PIR price. 2. Then if the PIR price and Invoice price don't match up, color code the Invoice with...

Hello I am trying to figure out how to format an IF statement, I want to perform a calculation within the logical test the true or false statement will then complete either one calculation if false or another calculation if true, see below =IF(s40*u40)>=u36,(s40-u36),(s40*u40) Basically if...

So i was given this question by my teacher and i solved it. 1. Copy the data onto a new worksheet. 2. It has been decided to offer a place if an applicant has a PASS in ANY THREE SUBJECTS for the next academic year. Modify the formula to cater for the new rule. HINT: There are 4...

Hi all. I hope you are well. I am trying to work on an If statement and I hope you can help. What I am trying to achieve is this IF Cell O4 = "YES" and C4 <11 and F4 is between 0 and 1 and I4 is between 0 and 1, and L4 is between 0 and 1 then Sum C4, F4, I4 I have attached a picture of my...

Hi All Having a brain fade, simply put if my formula returns a number >= 4 I want to make it 3, if its not I want to return the native value. Formula below. =IF((IFERROR(VLOOKUP($B7,'SharePoint Data SHC'!$B:$GB,Q$4,FALSE),0))>=4,3,IFERROR(VLOOKUP($B7,'SharePoint Data SHC'!$B:$GB,Q$4,FALSE),0))...

Hello, I need a formula that will look at a date and spit out a date 48 hours later. Here's my problem, It has to exclude the weekends? Here is the formula I'm currently using, however it seems very accurate excluding the weekends. =IF(WEEKDAY(I25+5)=1,I25+6,IF(WEEKDAY(I25+5)=7,I25+7,I25+4))...

Hello Cell N15 may contain the text <tbody> N 003. N 004. N 022. N 040. N 049. N 071. N 073. N 081. N 087. N 090. N 091. N 093. N 095. N 098. N 099. N 103. N 115. N 119. N 121. N 127. N 133. N 146. N 164. N 166. N 169. N 173. N 179. N 180...

hello all - what i am trying to do is take the values from a timeline slicer and use them in an IF statement. the formula would look somnthing like this in excel =if((Date)=(Slicer_Datekey),True,False) the slicer_datekey could contain multiple dates. any ideas on how i would approach this? thanks

=IF(AE2<=30, J2,IF(AE2>30,V2)) This formula works fine; however, I need it to also be based on column AF=0. I've tried (and , but can't seem to get the sequence correct. If col AF=0, and AE2<=30, return J2 If col AF=0, and AE2>30, return V2 if col AF isn't = to 0 "conditions"

I need some help with an IF statement. I am checking a code vs another code cell. The appears ###/####. What I want the formula to check if the referencing cell is <= to other, and then return one of the respective text strings I enter for true and false. I believe the issue I am having is...

Hi excel gurus, I have a bit of a dilemma in regards to an IF formula, here is a breakdown of the issue i am facing: I have a commission structure: £0-12,000 = 10% £12,001 – £24,000 = 15% £24,001+ = 20% This is worked out on what we have done in the month – but isn’t as simple as one fixed...

Hello Friends, I have two tables in one sheet. first table includes three columns and many rows and the second one also has some rows and columns. In the second table headers are "Product Name", "Price 1" and "Price 2" In first table I want to make a drop down list in first column of a row, in a...

Hello, I am trying to find the right formula to use in my spreadsheet for work to calculate my specialists processing and average time. I have several columns with large data but every month I need to know the average processing time by for each specialists. I am sure this question has been...

IF(H8="",IF(G8="",IF(F8="",IF(I8="",IF(J8="",IF(K8="",IF(D8="",IF(P8="","","Yet to Start"),"Awaiting Response"),"Awaiting Workstream Lead Review"),"Awaiting Design Team / Business Traige"),"Awaiting for Further Information"),"Response Received"),"Triage Complete"),"Review Complete") D...

I am trying to build conditional formatting for a report I run daily. There are certain criteria that I want to "pop" out drawing immediate attention. I want build it so that the variables in column O (several) are true column W (several) are true and Column if Blank =AND($O1="BR- PAP New...