Copied cells not recognized come printer time

2023-12-27 Thread Snapafun
Sorry. May have done this twice not recognizing 1st attempt was to user_subscribe list. Hi Guess I'm missing something here. In sheets I've formatted my efforts into A5 Landscape and can print that out fine (albeit as top of A4 sheet) So to get two copies onto the single sheet I copied and p

Spreadsheet Formula Hiding "0"

2020-06-01 Thread Snapafun
Great suite - Thanks. I love to hide the "0" value in cells yet to be populated and to do so I use the =IF(Target Cell>0;Actual Formula;"") setup. This works well for me upon the Target Cell being the result or a manual entry. However, this doesn't work when the Target Cell contains a formu