Hola gurus,
I have a number of nested formulas that are becoming somewhat laborious. I now realize that I need even one more added to each part in order to return a null string should the lookup value be equal to zero.
I am requesting assistance in what, on the surface to me logically seems like a scan of my array for zeros, whereby they would then be null (blank), but without erasing the formulas from the cell.
I would like to add this additional functionallity to some code I have already written in which my presentation (we'll call it that) is formatted, which is initiated by a click event.
I would assume that that the format would hide the unused rows (my code already) and then go through each cell in a specified array and nullify any zero values, but without erasing the formula contents of the cell (preserving the formula for future use whereby that cell might not be zero).
I really, really appreciate any insight or thoughts.
Bookmarks