Error being returned

[Pat]

This following formula is returning #VALUE!
=P207/1.4

I have tried to modify with the following:

=IF((ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4,0))

It is obviously not correct, can someone help with this?
Thanks
Pat

 

[N Harkawat]

=IF(ISERROR(Sheet1!P207/1.4)," ",(Sheet1!p207/1.4))
would be the correct syntax

 

[Bernard Liengme]

What do you get with =ISNUMBER(P207)?

 

[Pat]

What do you get with =ISNUMBER(P207)?
FALSE

What do you get with =ISNUMBER(P207)?

 

[Guest]

False, of course indicates that P207 is not a number;
Non-numbers divided by 1.4 would naturally yeild #VALUE!
HTH