| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
