and and or if statement

Hi. I have two sheets that I have to get data from each other. I have multiple criteria and I want to downsize my formula length. If any alternative way you know please enlighten me. In the first sheet I have 2722 rows. My criteria are performance score of employees, their score of grades and...

The formula I am using is not calculating correctly. What am I doing wrong? =IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98)))) What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains...

I've set the below formula. It works great when Activity 1-3 have been selected for Pass/Fail. =IF((AND(D20="Pass",D21="Pass",D22="Pass")),"Pass","Fail") However, if the Activity section hasn't been filled out yet (or are blank), the Outcome in B35 - B37 default as "Fail" If the criteria...

Will you please help me with a formula for the following? If the value in M2>$6000 then $6000. If the value in M2<$6000 then the actual value of M2.

Hi, I'd like to a VBA IF function with two conditions but am struggling to code it. So ideally the code would work like below but it doesn't work. If Cell.Interior.Color = RGB(217, 217, 217) and If cell.Font.Bold = True Then Any help is appreciated. Thanks, Paul

Hello - I am looking to create a formula that will return 'YES' or 'NO' based on different factors.... Without going into detail on the other parts of the formula unless necessary, the entire formula works until I added the bolded section below...

Team, the code and formulas i have typed into a few of my cells trying to figure this out has turned into a monster i have lost control of. Details are below. This spreadsheet is used to summarize overtime for everyone on a shift for a single day. Column F gets numbers manually entered. Column...

I would like to calculate the Maximum date resolved from a column of resolved dates, unless there are blanks in the resolved dates column. If there are blank cells in the column, I would like the result to come back as blank. The intent is to highlight whether there are outstanding service...

Hi, I am doing my head in with this formula and was wondering if someone could help me please?? :confused: <tbody> Description Code Rent for Store - April 2015 123/001 Rent for Apartment - April 2015 123/001 Office Room Hire - April 2015 123/001 Client payment on account 123/001...

Hello, I'm trying to make an if statement where if one cell equals "BZ" and another cell doesn't equal one of several values then a 1 is displayed. My current attempt is not working: =IF(OR(LEFT($O2,4)<>"0940",LEFT($O2,4)<>"0950",LEFT($O2,4)<>"0740",AND(AB$1=$Q2)),1,"") Any ideas?