if this and this then

  1. T

    If this Date Range and This Cell Value Match?

    Hello, I am trying to highlight a collision if the date ranges in columns B and C coincide as well as the values in column F. The collision column G should then be either red, or indicate yes or an x. How would I express this? Thank you!
  2. A

    If THIS and THAT, then add TOTALS

    Hello everyone! I'm trying to create a formula in order to be able to have the total hours per position an employee has worked on a different sheet on our database so that i just have to go to that sheet and look for an employee name and have their total shifts worked, total hours worked as a...

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