Hi Stuart

One way:

=IF(ISERROR(Your formula),0,Your formula)

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Stuart" skrev i en meddelelse
...
hi

im playing with a spreadsheet at the moment trying to use vlookup which i
have working

however, instead of when the vlookup value providing a value of n/a when
false, is there a way that i can use an if statement to return a value of
"0"
(zero)

thanks

stuart