or statement

1. Help for Nested Conditionals (IF/AND/OR/SUMIF etc.)

Hello and Good Day! I have an issue with writing a proper conditional formula in Excel, so please help me Elaborating my issue, Column A are Fruits; They either have "Oranges", "Apples", or "Pears" Column B are Client's Names I'll input the gross income on C Result for net income will be...
2. Conditional Formatting Multiple Criteria

I want to apply conditional formatting to column M based on the wavelength in column G. I do not want to compare it to the actual wavelength but a criteria based on the different wavelength. So 1310 would have have max value of .4500, 1550 would have have a max value of .2500 and 1625 would have...
3. IF statement followed by a SUM

Hi guys, I'm trying to create a formula to look into a box and sum up how many of x application are within a certain column. So for example i have the below <tbody> Username Notes Resolution User1 This is the notes field where application thisisapplication1 is held as proof for blah YES...
4. if & Or statement in VBA.

Here are my code: Sub GL()With Application .EnableEvents = False .ScreenUpdating = False End With Dim i As Integer For i = 2 To 20000 If Trim(ThisWorkbook.Sheets("FRA&FFC").Cells(i, 6).Text) <> "" Then If...
5. Change value fields in Pivot using VBA

Hi, I hope someone can help me, regarding change value fields in a pivot using VBA coding. I total I have 4 different fields that I want to users to be able to switch between, Units, Value in EUR, Value in USD and Value in DKK via dedicated buttons. Now here is the problem. Regardless of which...
6. Want to Combine 2 Separate and Opposite IF(AND Statements

The two IF(AND statements I currently am using are the opposite of each other to compare column C to F and then F to C: =IF(AND(C3="NOT FOUND",F3<>"NOT FOUND"),"CHECK","OK") =IF(AND(F3="NOT FOUND",C3<>"NOT FOUND"),"CHECK","OK") Is there any way of combining the two (maybe with an OR statement?)...
7. Send emails Outlook using or statement

Hello, I have this piece of code that is not delivering the result I intend, but I can't figure out what is wrong. Using OR Statement, in the first line of the piece of code below, I thought that it would send one email even if both YYY and ZZZ were present. Instead it sends two emails if both...
8. Need some help with an IF OR Forumla for my spreadsheet

I have a somewhat different billing system. 1st User= 4 files minimum additional Users= 3 file minimum ex: 2 user= 7 files minimum (4 +3) 3users= 10 files 4users= 13 files A1 is # of users and A2 column is minimum # of files needed (based on # of users) I am not sure how to write the...
9. Help with Averageifs and Or Statement

Good Afternoon - I am having a problem with averageifs and or combination. It is not working like I have expected it to, and I have not been able to find a solution to my problem on-line. I am looking at the following table: <colgroup><col span="2"><col><col><col></colgroup><tbody> Bank...
10. Conditional Formatting with OR: statement isn't working with two conditions

I have 3 Cells I'm working with. N, O, Q My Conditional Formatting Formula is as follows: =OR(\$N260+\$O260<>\$Q260,\$O260<>\$Q260) The conditional format is in Column Q applying to cells 260-325. I want to Highlight any cell within \$Q\$260:\$Q\$325 YELLOW if any number other than \$O260=\$Q260 OR the...
11. IF AND OR statement

Hi, I have been working on this formula for hours and cannot get it right. Please help! Column C has either TRUE or FALSE. Columns L and M have either a number or #N/A (depending on whether there was a number on the source data - this data has come from a vlookup). What I want, in column N...
12. Need some help with IF statements

Hello All, I'm having trouble with some IF statements, effectively what I need to do is report peoples time logged in the office. So from 20th of October people should have logged 39 hours, the next week people should have logged 78 hours and so on. Lets say this information is held in cell...
13. Need AND in Macro between two IFS

Please can someone help me to work out how to change this macro so that both statements need to be true, rather than both running but bringing back results of both: Sub CopyAtt1() Application.ScreenUpdating = False Application.StatusBar = "Please be patient..."...
14. Conditional Formatting using OR and INDIRECT

I want to use the following conditional format to highlight the row when anyone of these three is chosen from a drop down menu but nothing happens. I can however break it into 3 different conditional formats which works great but I want to apply this rule to several sheets thereby cutting it...
15. Combine Vlookup with If & OR statements?

I'm trying to get this equation to look for data that approximately matches data in 3 columns. In this case the data is usernames and I need to match one of three potential user names to ones that are in a different sheet column. Currently this is the equation that I am trying to use...
16. Conditional Formatting: Relative Reference? Using Or Formula?

I have Googled and researched this long enough, maybe its out there but I am missing it; if so I'm sorry. Here is what I am trying to do. I have made a spreadsheet that will act as a Clabber scorecard (a card game kind of like Euchre) instead of using a pen and paper. the programming works...
17. Calculating whether a person has upgraded between lists

Hello, I am trying to write a formula that isn't a gigantic IF statement to calculate whether a person has upgraded their type of house or not within a time period. The below are the names of the types of housing. I have two of these lists, the first is from the beginning of the time period...
18. Macro Help - IF statement with OR and AND

Hi I'm struggling to create a macro that will check each cell in Columns B and E and do the following: if cell in column B = London or Washington or Paris or Brussels (there are dozens of cities but I won't list them all)! and if cell in column E is blank then insert "text" into column E...
19. Data in columns A or B = number, display in column C

I have 2 columns, either they are both false, or 1 is a number. If one is a number, i want to copy that value to column C. <colgroup> </colgroup><tbody> 0.00032 FALSE 0.000855 FALSE 5E-06 FALSE FALSE 0.00037...
20. =if(or()) with another workbook

With the following formula I keep receiving #Value. =IF(OR('[NEF.xls]NEFAR MASTER LIST'!\$C\$90:\$C\$96='Sheet2'!D2),'Sheet2'!E2,"") I would like it to return the value from E2 if D2 value is equal to any of the numbers between C90 and C96, if not do nothing. Any ideas why this is not working?

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?

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

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