Logical function

L

Lavanya

Hi,
I am trying to apply conditional formatting if one of two column is not
divisible by 5. which logical function should i be using? can someone help?
Can i say something like IF(=or(A2/5, B2/5), "True")?
 
T

T. Valko

What if both cells are not divisible by 5? It that ok?

=AND(COUNT(A2,B2)=2,OR(MOD(A2,5)>0,MOD(B2,5)>0))

Biff
 
Top