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.