How to remove the #Value error while leaving the formula in cell?
The formula is:
Then the error message "# Value!" is caused by a text input or space in your cell calculation. It's better avoid this kind of data entry.
Thanks to Mike-31
for this tip.
Published by aakai1056
Latest update on December 8, 2011 at 05:02 AM by aakai1056.