View Single Post
  #4   Report Post  
Pat
 
Posts: n/a
Default

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