Formula value display
Try this:
A1 = 100
B1 = 25
C1 = formula:
=IF(B1="","",A1-B1)
Copy down as needed.
A2 = formula:
=IF(C1="","",C1)
Copy down as needed.
Biff
"drk442" wrote in message
...
I have a a spreadsheet where I substract column B from A and show results
in
C. Then C is sent to column A one row down. When I drag the formulas
down
so that they repeat I get an entry in column A & C. Is there a way to not
have the formula value show up until an entry is entered in Colum B?
|