You could use the IF function with your current formula. For example:

=IF(F6="","",F6*12)

Steve D wrote:
I believe this is possible but I can't remember how I did it in the past...

I have a pivot table that has formulas to the right and depending on the
filter I use I can have anywhere from 5 rows of data to 30,000 rows. How can
I have the formulas only appear where there is data? So if I have 5 records I
would have 5 rows of formulas and if I have 30,000 records I would have
30,000 rows of formulas.

Is this possible?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html