or statement

  1. 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?
  2. M

    Use COUNTIF with OR condition

    Hello, I am stumped. I have a spreadsheet with three date columns. I want to create a tally that will count each row only once if any of the three columns contains a date greater than 7/1/2011. Here is my formula for tallying just one column: =COUNTIF('Deduped Lead Contact...
    • MeredithS
    • Thread
    • countif excel multiple critera or condition or statement
    • Replies: 4
    • Forum: Excel Questions
  3. F

    If And Or Formula

    Hi! I am trying to build a if/and/or formula that i am having some trouble with. Currently i have the below formula that works =IF(CAPI?="no",FLOOR(((Annual_Constraint-H19)/(1+G18)),5000),IF(OR(CAPI?="yes",CAPI_YRs=1,CAPI_YRs=2,CAPI_YRs=3),0,FLOOR(((Annual_Constraint-H19)/(1+G18)),5000)))...
    • fedas18
    • Thread
    • and statement formula if statements or statement
    • Replies: 1
    • Forum: Excel Questions
  4. H

    [SOLVED] Using OR statement in FormulaArray

    I seem to be stuck trying to use multiple variables in an array statement. =SUM(IF(Hours!$A$2:$A$13189=HR!$A5,IF(OR(Hours!$B$2:$B$13189="ENG",Hours!$B$2:$B$13189="SNRENG"),Hours!$D$2:$D$13189,),)) Right now it sums everything if the first expression passes, so if the Hours column A matches...
    • hoffey
    • Thread
    • array formulaarray multiple variables or statement
    • Replies: 6
    • Forum: Excel Questions
  5. P

    If statement with multiple ORs

    Hello, So I am performing a sum if the value from a cell is equal to any one of the multiple conditions I am providing in separate cells. The formula I currently have works, however it is very bulky because I have three conditions I want to compare to. This is what I have: =IF(OR($'Complete...
    • playpbateman
    • Thread
    • if statement multiple conditions or statement simplify simplify sumif
    • Replies: 6
    • Forum: Excel Questions
  6. D

    Data Validation Source Statements

    Hello Guys, Quick Question, I have a data validation box and a vlookup in order to get descriptions when a job description is chosen from the data validation box. I now need to to do the same reversed, this in theory is simple however, if i type the description ill need the Job Number to...
  7. K

    Hyperion Data Retrieving and Cell Data issue

    Hello erveryone! For those who know it, I'm using Hyperion to retrieve sales data from a database. Everything works fine exepted that hyperion fills < '0 > instead of < 0 > when the data is not available (most of the time it means 0). The problem is the following, I use formulas that test...

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