Newbie question Pulling data from one sheet to another based on

Wow, sooo close.

I added a Qty column and then a Price column. Then I used the formula
=(E3*D3) copied down.

Works great except for the cells that have no data, I get a #Value
error. As sson as there is data in the field it all works well enough
for my purpose but how can I hide, or fix this?


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile: http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640

Glad you liked it !
... please tell your ... that you are a ...
... only at the immeasurable risk of feeling very mortal ! g
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

=if(iserror(e3*d3),"",e3*d3)
or
if(or(isblank(e3),isblank(d3)),"",e3*d3)
************
Anne Troy
www.OfficeArticles.com

"Tony Canevaro"
wrote in message
news:Tony.Canevaro.1xfweb_1130213112.422@excelforu m-nospam.com...

Wow, sooo close.

I added a Qty column and then a Price column. Then I used the formula
=(E3*D3) copied down.

Works great except for the cells that have no data, I get a #Value
error. As sson as there is data in the field it all works well enough
for my purpose but how can I hide, or fix this?


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile:
http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640

Another alternative (along the same lines as the error trap used in col D in
the sample's set-up) with "Qty" input in E3 down and "Price" to be
calculated in F3 down ..

Put in F3, copy down: =IF(OR(D3="",E3=""),"",E3*D3)

Or, we could amend the 1st part of the formula in col D
to return zeros instead of blanks: ""
(the null string "" is what causes the downstream error #VALUE! in col F)

i.e. use in D3, copied down: =IF(OR(A3="",C3=""),0, ...
instead of: =IF(OR(A3="",C3=""),"", ...

Then to calc the price, just use in F3, copied down: =E3*D3

New lines w/o data will then simply show up as zeros in cols D & F

And if desired, for a cleaner look,
we could suppress the display of zeros in the sheet via clicking:
Tools Options View tab Uncheck "Zero values" OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Anne and Max the God and Goddess of Excel!

Seriously, thanks very much both of you. I learned a fair bit.

Still not "Why" you do the crazy stuff you you do but a bit of how.


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile: http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640

You're welcome, Tony !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Anne imagines self in long flowing white with gold accessories, her Excel
tiara set slightly off-center atop her tresses, which are being blown gently
by the wind...then wakes up.
You're welcome, Tony!
************
Anne Troy
www.OfficeArticles.com

"Tony Canevaro"
wrote in message
news:Tony.Canevaro.1xg4qm_1130224157.0114@excelfor um-nospam.com...

Anne and Max the God and Goddess of Excel!

Seriously, thanks very much both of you. I learned a fair bit.

Still not "Why" you do the crazy stuff you you do but a bit of how.


--
Tony Canevaro
------------------------------------------------------------------------
Tony Canevaro's Profile:
http://www.excelforum.com/member.php...o&userid=28292
View this thread: http://www.excelforum.com/showthread...hreadid=478640