determine if your formula will return a zero using an if statement...

If(formula = 0, "", formula)
--
HTH...

Jim Thomlinson


"FP Novice" wrote:

I am using some lookup functions in multiple cells of a spreadsheet.
Depending on the search a cell may actually have a null value. When a null
value is returned the cell is populated with a '0'. My question is how do I
make it so a null value is simply an empty cell?

Thank you,
Todd