Maybe

=IF(ISERROR(YourFormula),"",YourFormula)

Mike

"RobertSE6" wrote:

In the form I'm working on the user puts in a couple of values to get an
answer - is there a way to stop #VALUE! being displayed in the result cell
before they put in the values in the other cells - if you see what I mean

Thanks

Rob