It worked!!
Thank you everyone for your help, I was going crazy trying to figure it out!!!
Have a great day!
--
-H


"Tom Ogilvy" wrote:

Column F will show #N/A if column E shows #N/A. to avoid it, in F2 for
example, use:

=if(iserror(E2),"",D2*E2)

--
Regards,
Tom Ogilvy


"H" wrote in message
...
Column D is a number entered manually
Column E has an HLOOKUP formula in it
Column F is D*E
I can add column D no problem
When I try to add column F I get an error- #N/A
Does anyone know how I can copy this column?
Thank you,
--
-H