Formula value display

[Guest]

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?

 

[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

 

[Guest]

May be this is what you are looking for:

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

Hope this help, let us know!

 

[Guest]

this worked, thanks a lot

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

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

this worked, thanks a lot