A ant Nov 7, 2003 #1 how to you right not equl ina formaul for ex, if A2 is not equal to 0 than hello
B Bob Phillips Nov 7, 2003 #2 Ant, =IF(A2<>0,"hello","goodbye") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Ant, =IF(A2<>0,"hello","goodbye") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)