Thread: USING IF AND PROBLEM
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default USING IF AND PROBLEM
=IF(AND(E9=1,ISNUMBER(Z9)),Y9*$AO$7,0)
--
David Biddulph

"Amanda" wrote in message
...
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




Reply With QuoteReply With Quote