Ok here is my formula

=IF(N3*$o$1="","",(N3*$o$1)

I copied the formula down it works as long as there is a value in say N3 if
there is a formula in the column the result is #Value!

I hope I am explaining this right.

thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1