Jane
05-03-2005, 12:21 PM
In a Excel spreadsheet showing as below, a same formula (e2=d1+e1, e3=d2+e2, e4=d3+e3, ----) is used from cells e2 to e11. How to make the cells from e4 to e11 to keep blank until cells d4 to d11 have values filled. Thank you very much!
C D E1 $ 456.00 $ 8,799.00 2 $ 8,799.00 $ 9,255.00 3 $ 456.00 $18,054.00 4 $18,510.00 5 $18,510.00 6 $18,510.00 7 $18,510.00 8 $18,510.00 9 $18,510.00 10 $18,510.00 11 $18,510.00
C D E1 $ 456.00 $ 8,799.00 2 $ 8,799.00 $ 9,255.00 3 $ 456.00 $18,054.00 4 $18,510.00 5 $18,510.00 6 $18,510.00 7 $18,510.00 8 $18,510.00 9 $18,510.00 10 $18,510.00 11 $18,510.00