Multiple IF And Or formula

[Nagin]

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

 

[Marc L]

Hi !

Better is to join a sample workbook !
​

 

[Nagin]

Hi Marc,

Ive attached a sample data set

Thanks

 

[Marc L]

C2 formula :​

=IF(A2="Moderate",IF(B2>90,"Over 90","Within 90"),IF(OR(A2="Historic IMR",A2="Major",A2="Minor"),IF(B2>28,"Over 28","Within 28"),""))

Copy down …
​

 

[Nagin]

Hi Marc,

Thanks, that worked perfectly