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

"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