orfunction

  1. U

    Excel Formula Query - Adding OR to function

    Hi aLL, Have the following formula which works fine, however want to add to it so that it looks for not just the text "A1" but also "B1", how can i amend the below formula? =IF(RIGHT(TRIM(D2),2)="A1","YES","NO") Thanks,
  2. E

    How to cross reference a cell with different names?

    Hi All! I am a first time poster long time stalker:). I am trying to do some type of Vlookup between two pivot tables. Both pivot tables have the same data but some of the names are different because it derived from a different source but they have the same data I want. For Example: <tbody>...
  3. R

    Conditional Formatting with OR

    Hello. Looking to do conditional formatting for a cell (A5) to turn color when: E5="CP","CP-G","CP-GI","CP-D","CP-ETF","CP-G/D","CP-G/GI","CP-G/ETF","CP-D/GI","CP-D/ETF","CP-GI/ETF") I was using 'use a formula to determine which cells to format" and using an OR function but couldn't get it to...

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