Formula value display

D

drk442

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?
 
B

Biff

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
 
R

RajKohli

May be this is what you are looking for:

=IF(B1>0,B1-A1,"")

Hope this help, let us know!
 
D

drk442

this worked, thanks a lot

Biff said:
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
Click to expand...
 
Top