Hey all,
I have the following difficulty:
Formula:Please Login or Register to view this content.
this function does not work as I want it to, which surprised me, bc in seperation both of the formulas (the IF & the IFERROR) work as desired.
With the function I refer to a cell, that either has a value (in text form), is blank or contains "-".
In the two later cases I want the cell to be blank, in the first I want the value as a number.
Looking forward to your smart solutions,
Laurents
Bookmarks