Hi,
I have a formula
=IF(OR($AP2="PZ",$AR2="PZ"),"PZ",+IF(OR($AP2="SZ",$AR2="SZ"),"SZ"))
which does exactly what I want, except when neither of the conditions are true, it returns "False". My question is how can I change things so that the word "None" is displayed instead of "False"?
Any help gratefully received.
Phil
I have a formula
=IF(OR($AP2="PZ",$AR2="PZ"),"PZ",+IF(OR($AP2="SZ",$AR2="SZ"),"SZ"))
which does exactly what I want, except when neither of the conditions are true, it returns "False". My question is how can I change things so that the word "None" is displayed instead of "False"?
Any help gratefully received.
Phil