Excel 2007 : If Then Statement meeting multiple criteria

Hello,

I need an "If then" statement that will calculate if a row meets the SLA.

I have attached a demo spreadsheet.

Column A-Start Date and Time
Column B-End Date and Time
Column C-Hours to Process
Column D-Days to Process
Column E-Queue
Column F-SLA Standard (should be 1 if it meets the standard and 0 if it does not)
Column H and I-used to calculate column C

Queues with an SLA less then 3 days: C02, C30
Queues with an SLA less then 2 days:C12, C29, C33, C34
Queues with an SLA less then 1 day:C08, C09, C10, C16, C17, C50
Queues with an SLA less then 4 hours: C32

This formula works if you want to do it line by line: =if(D5>3,0,1)

However, I need one that reads like this:
if Column E equals C02 or C30 and Column D is greater than 3 hours than Column F equals 0 esle 1 or if Column E equals C12, C29, C33, C34 and Column D is greater than 2hours than Column F equals 0 esle 1... and so on

Thanks for the help

Perhaps?

Please Login or Register  to view this content.

copied down.

See attached.

If you wanted the reverse.. then take the NOT() out...

The -- converts the actual TRUE/FALSE boolean result of the base formula.. NOT(......) to 1 and 0 respectively.