In Column C I have Production. In column D I have Goal. In Column E I have variance %. My formula is =(D11-C11)/D11
However, how do you hide the cells down the sheet until you put something in D11
& C11
to hide #DIV/0!
. I have tried using the IF
formula but seem to get it wrong?
No comments:
Post a Comment