#Value! Result

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