or statement

  1. A

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    =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?

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top