-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
and and or if statement
-
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...- destiny4adams
- Thread
- and & or statements and and or if statement calculate complex calculations condition formula multiple ands multiple arguments time analysis
- Replies: 15
- Forum: Excel Questions
-
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...- jayjay123
- Thread
- and and or if statement blank cell formula
- Replies: 2
- Forum: Excel Questions
-
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.- ArtBOM
- Thread
- and and or if statement
- Replies: 3
- Forum: Excel Questions
-
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- smitpau
- Thread
- and and or if statement vba
- Replies: 1
- Forum: Excel Questions
-
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...- RJB78
- Thread
- and & or statement and and or if statement if(
- Replies: 3
- Forum: Excel Questions
-
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...- ConnerR
- Thread
- and and or if statement funcation logic flaw sumifs
- Replies: 4
- Forum: Excel Questions
-
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...- Jacilyn
- Thread
- and and or if statement blank column max resolved
- Replies: 2
- Forum: Excel Questions
-
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...- tlc53
- Thread
- 123/001 and and or if statement excel 2010 formula if statement
- Replies: 3
- Forum: Excel Questions
-
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?- misk0048
- Thread
- and and or if statement cell displayed statement values
- Replies: 7
- Forum: Excel Questions
