Hello I want cell U2 with =(52-T2)/52 to be blank until data is added to to T2 cell at the moment it shows 100%. I can then copy rhis to the other 300 cells.Thanks Sean
I omitted the equal sign "=" in front of the formula so it should actually be =IF(ISBLANK(T2),"",(52-T2)/52)
Thanks Eric10 for the help. The sheet looks a lot better now.
One more question. Is it possible to have the cell automatically change colour if say the sum is less than 50%?
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.