or statement

Hello, I'm wondering if it's possible to use the OR statement with Not Equal To (<>) in VBA. I'm trying to simplify the user selection from a MsgBox to validate the entries and then Exit Sub if no valid matches were found, Else proceed with running the Macro. Here's what I'm working with...

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

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

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

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

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

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?)...

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

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

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

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

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

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

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

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

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

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

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

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

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