View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default 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?