IF and ISNA trouble

[piguy]

Not sure what I'm doing wrong. Tried a couple of things but cannot get to work. Trying to remove "######" from cell when time is left blank.

here is formula:

=IF(ISNA(F6-TIME(1,0,0)),"test",(F6-TIME(1,0,0)))

if there is no time entered in cell F6, I'd like it to say "test"

 

[Jonmo1]

SQRT(-1) = i
i^2 = -1

http://en.wikipedia.org/wiki/Imaginary_number

:S

But I do take your point!

Regards
Adam

Yep, I googled it too.
It's too bad Excel doesn't have an imagination....

Good discussion though..

 

[adam087]

To be honest, I'm not sure my imagination is really up to the task. I get an odd facial expression when I try and think of a number that I can't look at :S

 

[Jonmo1]

Thanks Jonmo. That'll do it!

Sorry, we kinda got sidetracked...

Glad to help, thanks for the feedback.