Association between the OR function and the AND function

Highlighted
Occasional Visitor

Hello

 

I don´t know if I can associate this two functions;

 

IF(OR(AND(V15>=$X$1;V15<$X$2;G15=0;C15=0;D15<=1;E15<>0;J15<>0);"";"");(AND(V15>=$X$1;V15<$X$2;G15=0;C15=0;D15<=1;E15<>0;J15<>0;r15<>0);"";"");"SILVER;"")

 

Can anybody help me please?

Thank you

1 Reply
Highlighted

@cjcunha 

Your formula is

IF(OR(AND(...);"";"");(AND(...);"";"");"SILVER;"")

which definitely doesn't work. Perhaps you mean something like

IF( OR( AND(...); AND(...)); "SILVER; "")