USING IF AND PROBLEM

Amanda · Aug 2, 2007

Hi Guys

Cell Z9 will have a payment date in.

I need to say

IF E9=1 & Z9 "has a date in" then (Y9*$AO$7,0)

Please can anybody help?
Amanda

David Biddulph · Aug 2, 2007

=IF(AND(E9=1,ISNUMBER(Z9)),Y9*$AO$7,0)

Amanda · Aug 2, 2007

Thanks David

Perfect!

David Biddulph said:
=IF(AND(E9=1,ISNUMBER(Z9)),Y9*$AO$7,0)