How do I blank cells that haven't been calculated yet.. 2

[proflola]

Hello,

I have formula that calculates on each row. I would like to copy the formula down several rows, however the last value stays in the rows that have no data to calculate.

Sample:

Income Expense Balance
2200 1100 1100 (formula: =a2-b2)
500 600 (formula: =c2-b2)
600 (formula: =c3-b3)
600
600
I once had a formula that would make the value "0" until values were added. I can't remember how I did it. Do you have any ideas?

--Sandy

 

[SkipVought]

Hi,

[tt]
if(isblank(a2),"",a2-b2)
[/tt]


Skip,
[sub]
[red][/red]
[/sub]

 

[proflola]

NEVERMIND....I figured it out myself...

=IF(ISBLANK(B6),0,(C5-B6))


----Sandy

 

[proflola]

Skip,

Thanks for your response. At least now, I also know how to blank the cell, too.

Sandy

 

[SkipVought]

CAVEAT:

Entering formulas in unused rows creates a nuisance when printing. Use your AutoFilter to filter out the empty rows.

Skip,
[sub]
[red][/red]
[/sub]

 

[proflola]

Thanks again, Skip!

 

[AnotherHiggins]

Have a look at Tools > Options then go to the Edit tab and check the Extend list formats and formulas.

Assuming that you autofill at least 4 rows with the formula, then it will automatically appear when the feeder cells are populated.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[yogia]

Have a look at Tools > Options then go to the Edit tab and check the Extend list formats and formulas.

Assuming that you autofill at least 4 rows with the formula, then it will automatically appear when the feeder cells are populated.

Good Call ... Thanks John!

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com