"joeu2004" wrote in message
...
Except when G12 might contain "", for example due to an IF()

However, surely in case there is an argument in favour of returning a
#VALUE! error rather than using N() which, in the second reference, will
return zero and thus produce a wrong result which may go unnoticed. If
there is going to be a problem I would rather know about it than have XL
hide the fact.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk