Hi All,
I have been trying create a multiple AND, Or formula, I have attached below a sample dataset, I am trying to write a formula in column C (Time Taken), which first looks at Column A (IMR Type), if column A includes any of the following; Historic IMR, Minor or Major AND is below 28 then return "Within 28", else return "Over 28".
If Column A includes Moderate AND is below 90 then return "Within 90" else return "Over 90"
IMR Type Time Taken Time Band
Historic IMR 10
Minor 50
Moderate 95
Major 15
Help on this would be much appreciate.
Thanks
Nagin
I have been trying create a multiple AND, Or formula, I have attached below a sample dataset, I am trying to write a formula in column C (Time Taken), which first looks at Column A (IMR Type), if column A includes any of the following; Historic IMR, Minor or Major AND is below 28 then return "Within 28", else return "Over 28".
If Column A includes Moderate AND is below 90 then return "Within 90" else return "Over 90"
IMR Type Time Taken Time Band
Historic IMR 10
Minor 50
Moderate 95
Major 15
Help on this would be much appreciate.
Thanks
Nagin