Hard Formula

  • Thread starter Thread starter Ant
  • Start date Start date
A

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
 
=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)
 
Back
Top