I have the following statementin D4:-
=IF(OR(E4<C4,H4<C4,K4<C4,N4<C4,Q4<C4,T4<C4,W4<C4,Z4<C4,AC4<C4,AF4<C4,AI4<C4,AL4<C4,AO4<C4,AR4<C4,AU4<C4,AX4<C4,BA4<C4,BD4<C4,BG4<C4,BJ4<C4),"ALARM","OK")
However only E4 currently has any data in, the rest have #value. How do I get the statement to ignore the #value cells until they're populated?
Thanks
=IF(OR(E4<C4,H4<C4,K4<C4,N4<C4,Q4<C4,T4<C4,W4<C4,Z4<C4,AC4<C4,AF4<C4,AI4<C4,AL4<C4,AO4<C4,AR4<C4,AU4<C4,AX4<C4,BA4<C4,BD4<C4,BG4<C4,BJ4<C4),"ALARM","OK")
However only E4 currently has any data in, the rest have #value. How do I get the statement to ignore the #value cells until they're populated?
Thanks