How to keep cells with formulas blank until data is entered into a corresponding cell?

12 views
Skip to first unread message

Incurio Circio

unread,
Jan 4, 2025, 9:18:12 PMJan 4
to Google Sheets Community

EXAMPLE:

WANT CELLS IN COLUMNS C & D LEFT BLANK UNTIL

DATA IS ENTERED INTO CELLS IN COLUMN B


                      B                             C                         D

7              70,560.94.              378.63.              378.63

——————————————————————————————————

             (BLANK CELL)        WANT BLANK   WANT BLANK

               WHEN INPUT              RESULT           RESULT

8             71,787.19.                   1226.25           1604.88

FORMULAS IN CELLS>          (=B8-B7)         (=D7+C8)


FORMULAS PROGRESS FWD IN FUTURE RESPECTIVE CELLS


WANT>  (BLANK CELL)          BLANK              BLANK

9               NO DATA               - 71787.19        -70182.31


10             NO DATA                     0.00         -70182.31



Reply all
Reply to author
Forward
0 new messages