if/or statements

  1. L

    Nested or formula combinations

    Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...
    • LizzyG
    • Thread
    • conditional formaatting format formula if/ then if/or statements validation
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Formula Help: Possible Nested IF/AND issue

    I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated. If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’...
    • schmitkl
    • Thread
    • formula help if/ then if/and/or/not in excel if/or statements text
    • Replies: 2
    • Forum: Excel Questions
  3. M

    VBA to Hide/Unhide Worksheets using Checkboxes (FormControl or ActiveX) and IF statement

    I have been trying to create a code that would hide/unhide certain worksheets based on the value formulated in Column R resulting from the Checkbox control value in Column Q indicated by TRUE or FALSE. See below- <tbody> COLUMN Q COLUMN R Checkbox () Control Formula Sheet() Formulas...
    • michele_said
    • Thread
    • cell (value) checkbox hide/unhide sheets if/or statements multiple sheets
    • Replies: 3
    • Forum: Excel Questions
  4. S

    Which Function or combination?

    For some reason, I've got a mental block today. Here's what I want to do: Cell A1 = 100000 Cell A2 = 200000 Cell a3 = 150000 (this is the variable) If cell A3 is in the range of A1-A2, then return a formula: (A3-A1) *.01 If cell A3 is greater than cell A2, the return a set number: 1000. As a...

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