I want to show variance (i.e. =A2-A3), but I only want it to calculate if the cell is showing a number (i.e. A3)
so-
A2= 1 and A3= 1, then A4=2
but if-
A2=1 and A3= blank, then A4=blank (rather than -1)
Thanks for any help on this presumably basic matter...
Bookmarks