Hard Formula

[Ant]

This is my current formula in cell V2
=IF(OR(N2>0,Q2=0),"y","n")

However, i also want to say If cell A2 is blank, leave
cell V2 blank

Any ideas?

Thanks

Ant

 

[Dave R.]

=IF(A2="","",IF(OR(N2>0,Q2=0),"y","n"))

 

[Bob Phillips]

=IF(A2="","",IF(OR(N2>0,Q2=0),"y","n"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)