ExcelBanter - USING IF AND PROBLEM

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - USING IF AND PROBLEM (https://www.excelbanter.com/excel-worksheet-functions/152712-using-if-problem.html)

Amanda

USING IF AND PROBLEM

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[_2_]

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

Amanda

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

All times are GMT +1. The time now is 05:02 AM.