if(and)

  1. C

    IF(AND) returning FALSE value when it should be true

    Can someone help me with this formula please? Essentially "Overview!B*" is the period, and "Overview!D*" is the date. I know for a fact that the return value for the IF(AND) is TRUE, but when I evaluate it, it's saying it's FALSE...
  2. S

    Multiple if and parameters

    Hi, I am trying to allocate labor hours per week to meal periods using the employee time clock activity. My meal periods are: Breakfast 6:00 AM - 12:00 PM Lunch 12:01 PM-6:00PM Dinner 6:01PM - 12:00 AM Late night 12:01 AM-5:59AM The time clock activity gives Time in and time out. Most employees...
  3. A

    Formula that compares dates and then times from that date row and returns a result

    Hi I've got two data sets, on two sheets in the same workbook. The first is a set of columns signifying actions. It includes date, time action started and time action ended. The second is a set of resulting actions that may or may not have occurred on the same date and between the times. It...
  4. B

    percentile if and statement

    Hello, I have data with multiple columns. In one column I have months designated 1 - 12 (column C). In another column I have values such as temperature (column P). I am trying to calculate the 85th percentile of only the months may - October (5 - 10). I have tried a nested percentile if and...

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