how to remove #DIV/0!
Biff's method traps all errors and returns a zero instead of the error
message, whereas my method specifically avoids the #DIV/0 error, as you
requested. If A1 contained some text, then you would get the error
message #VALUE if you used my formula - just different approaches.
Pete
|