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

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

"Bernard Liengme" wrote in
message
...
What do you get with =ISNUMBER(P207)?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Pat" wrote in message
...
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





.