Removing #VALUE!

[Tim]

OK one more 'last' question...

In column K I total the result of the VLOOKUP * the quantity I enter into
column J, but if there's nothing in J it shows, #VALUE! It's just =I11*J11

How do I make it show nothing in the cell instead of #VALUE!.........?

[Chip Pearson]

Try

=IF(J11="","",J11*I11)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Tim" <[email protected]> wrote in message
news:[email protected]...
> OK one more 'last' question...
>
> In column K I total the result of the VLOOKUP * the quantity I
> enter into
> column J, but if there's nothing in J it shows, #VALUE! It's
> just =I11*J11
>
> How do I make it show nothing in the cell instead of
> #VALUE!.........?
>