I have a spreadsheet that i enter in new values everyday and want to have the equation run down the entire column so i don't have to drag the previous day's box down to copy the info.
It would work fine to drag the box all the way to the bottom of the sheet, but then the cells get filled with a 0.
How can i put the equation in the cells without having them give me a value right away? i.e. only have them show a value when the rest of that row has info in it
Not sure if Superuser is the right place...Mods feel free to move to appropriate site.