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