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

Try:
=IF(N3="","",N3*$O$1)

HTH
--
AP

"Darts via OfficeKB.com" <u19990@uwe a écrit dans le message de
news:5dd5917d4d79a@uwe...
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

Ardus Petus wrote:
Try:
=IF(N3="","",N3*$O$1)

HTH
--
AP

Ok here is my formula

[quoted text clipped - 6 lines]

thanks

Perfect !!!!!! Thanks a mill

--
Message posted via http://www.officekb.com