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
|