Worksheet generated by macro - how do I default cell display - need more help

I have a spreadsheet that is generated by a macro. In some of the cells, if there is no information on the data base, I would like it to read "none" WITHOUT madifing the macro.

Currently my spreadsheet cell B43 has the formula:

=FG_spp

If the data base shows no data for this cell, how do I modfy this formula to have the cell show the word "none"? Currently it shows "#NAME?".

Jassoncw said to try IF(ISERR(FG_spp),"none",FG_spp)).

It worked when there was no data in the database, but even when there is data, I get "none".

Any ideas how to fix it?

Thanks

woops, correction - Jassoncw said =IF(ISERR(FG_spp),"none",FG_spp).

This is the one that doesn't work when there is data in the database.