Thread: USING IF AND PROBLEM
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amanda Amanda is offline
external usenet poster
  
Posts: 151
Default USING IF AND PROBLEM

Thanks David

Perfect!


"David Biddulph" wrote:

=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