Thanks! Thats a HUGE help!
"Roger Govier" wrote:
Hi Steve
=IF(ISNA(your_formula),"",your_formula)
--
Regards
Roger Govier
"Steve )" <Steve
wrote in message
...
I'm using the VLOOKUP function to lookup inventory in our database. How
can
I set up the formula so that the #N/A will display 0 instead. I went to a
seminar and the instructor did this but I did not get to write the formula
down.
|