and and or if statement

  1. M

    Alternative way for long formula typed with IFS

    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...
  2. D

    Multiple conditions and arithmetic for one cell

    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...
  3. J

    IF cell contains multiple text return "Pass", "Fail" or "" (blank)

    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...
  4. A

    IF, AND

    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.
  5. S

    VBA - IF with And

    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
  6. R

    IF/AND/OR Nesting

    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...
  7. C

    SUMIFS with IF and AND functionality

    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...
  8. J

    Max unless blank

    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...
  9. tlc53

    AND/OR/IF Statement - Return list with no repetitions

    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...
  10. M

    Making IF Statement combining AND and OR

    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?

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top