I am trying to calculate a certain score in Excel, with the formula:
=0,012*(U2/R2)
Cell U2 contains nothing (blank)
Cell R2 contains 521993
Excel does not return an error, but returns a 0. This means that when I extend the formula, a wrong number will be returned. I need an error, just as Excel would normally give you. To enlighten you further, I attached a screenshot below.
Image1.png
Hopefully, someone has an idea what is going on. I feel like I am going mad.
All the best,
Guus Bronkhorst
Bookmarks