Passing multiple conditions

[clandestino800]

Dear all,

I am trying to pass several conditions depending on cell values
If B2 >=1 and F2>=1 = OK
IF B2>=1 and G2>=1 = Error
IF B2>=1 and C2>=1 = Open

Is there a way to get the "Status" with IF/AND & OR in cell H2

I'll be grateful for any tipps or recommendations

 

[rondeondo]

Hi,
yes, What do you want the output to be if more than one of c,d,e or F is >1?
For your example"

If(B2 >=1,IF(F2>=1,"OK",IF(G2>=1,"Error",IF(C2>=1,"Open","Pending")))

This will prioritise in order of F, G then C.

 

[clandestino800]

Hi,
yes, What do you want the output to be if more than one of c,d,e or F is >1?
For your example"

If(B2 >=1,IF(F2>=1,"OK",IF(G2>=1,"Error",IF(C2>=1,"Open","Pending")))

This will prioritise in order of F, G then C.

Hi Rondeondo,

thank you very much for your prompt reply. Prioritising got me to the result I was aiming for.

Regards