if or and

  1. L

    How to IF multiple options

    Hi, I have a problem where I have price data from one company and want to allign it to our products. Basically saying, if product A falls under these measurements it is in group 1. If Product A is in group 1 and has a weight of 1 KG the price is 1,00 but if the product is 2 KG the price is...
  2. V

    SUMIF with multiple criteria and first instance only

    Hi there - I'm trying to sum all of the data in column D that have either a yes in the primary or secondary category, but only include the first instance of that value. In the example below, the sum would be 3 (1 for A, 2 for B). Please help!! :) <tbody> Area Primary Site Secondary Site Value...
  3. apgmin

    If and formula

    What should be the formula for the following: If cell a1 is not empty then check cell b1, c1 and d1 only if all the above 3 cells b1, c1 and d1 are "yes" then the result should be "ok" If any of the above 3 cells b1, c1 and d1 are empty or anything other than yes then the result should be...

Watch MrExcel Video

This Week's Hot Topics

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
Top