You get that error if you try to do arithmetic on text values. The
only bit of arithmetic you are trying to do is to subtract U4 from V4.
Consequently, one, or both, of those cells contains some text (which
might happen to look like a numeric value or date). This might work
(using Gary''s formula):

=IF(V4="",0,V4*1-U4*1)

The *1 will try to convert the text value into a number.

Hope this helps.

Pete

On Aug 28, 3:22*pm, Clare wrote:
Hi

Tried this but it is coming with #Value! *Any other ideas
--
Clare



"Gary''s Student" wrote:
=IF(V4="",0,V4-U4)
--
Gary''s Student - gsnu200902- Hide quoted text -

- Show quoted text -