Hi Julie
wanted to write
ISNUMBER
Thanks for the correction
--
Regards
Frank Kabel
Frankfurt, Germany
"JulieD" schrieb im Newsbeitrag
...
Hi Frank
i thought the ISDATE() can only be used in VBA?
Cheers
julieD
"Frank Kabel" wrote in message
...
Hi
try
=IF(AND(A32="value 2",ISDATE(V32),COUNTIF(C77:C1000,BC1)),"Update","n ot
update")
"Pat" wrote:
In sheet P05 if A32 contains the value 2 and V32 contains a date and BC
matches sheet CC04 C77:C1000, return "Update"
Anyone know the formula for this?
Thanks if you can be of help.
Pat
|