Do you want every row to multiply by the value in cell B1? If so, use an
absolute reference, e.g.: =A3*$B$1

If that's not the problem, select one of the cells that's showing an
incorrect result. Click in the formula bar, and see which cells on the
worksheet are outlined with colour. Is there a value in each of those
cells?

Vickie wrote:
I am doing a simple formula of =A3*B1 or =A3*C1 etc and then using the + fill
handle bottom down each of the columns down about 20 rows or so and it
doesn't give me the correct amounts.

"Anne Troy" wrote:


Vickie: What's the formula you're copying?
************
Anne Troy
www.OfficeArticles.com

"Vickie" wrote in message
...

I can't seem to get the fill handle "+" sign to give the correct amounts
when
I want to copy a formula down a column. It seems to skip every 2nd row
with
the wrong amount or sometimes it will give a 0.00 sign.
Any suggestions.
Thanks in advance





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html