try

=IF( AND( ISNUMBER(C34), E34="Not Done"), NOW()-C34,"")

problem is that the function NOW() - C34 is #VALUE if C34 is not a number.

works better now?

JP


"Gus" schreef in bericht
...
Hi JP

Many thks for replying! I am trying to calculate the number of days
between
a deadline date (column C) and todays date if "Not done" is entered into
column E, alternative if text (or blank) is in Column C, then nothing is
returned.

The problem I have with the 1st IF statement (& also the one you
reccommended) is #VALUE! is displayed in the column when I have text
entered
in column c.

RD Gus


"Johannes" wrote:

Not sure what you're trying to do but definately you have some
bracket-problems on the second if-statement.

Maybe the one below helps:

= IF( ISNA(E35 = "Not Done"), "", IF( E35 = "Not Done", NOW() - C35,
""))

What is wrong with the first if-statement (it already returns "" if "Not
done" is not displayed)

JP


"Gus" schreef in bericht
...
Hi

Please could someone assist. I have a formular: =IF((E34="Not
Done"),NOW()-C34,"") which works but I am trying to return a "" value
when
"Not done" is not displayed. I have tried using
=IF(isna((E35="Not Done"),NOW()-C35,""),"",((E35="Not
Done"),NOW()-C35,""))
but this is not working.
Thks
Gus