Is there a way to get the exact output of a referenced cell?
I have tried playing with the cell format menu, but I can't get a satisfying result.
If I use "General", referenced blank cells becomes zeroes instead of blank cells. I just want blank cells to be blank when referenced and zeroes to be zeroes.
Is there a way to do this using the "Special" feature from the drop-down menu?