After Copy Past shows Error. (#VALUE!)

[khanjee]

All respected fellows,

When i copy past desired quantity in Qty row, (File attached) It show
error in "K" Cells (#VALUE!) & those cells which Qty Column are no
blank does not show error. (I want, without Qty, Cells should remai
blank)

Please guide me how can I resolve this.


Always regards
Desperately Waiting

+-------------------------------------------------------------------
|Filename: Excel error Snap.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=891
+-------------------------------------------------------------------

 

[joeu2004]

When i copy past desired quantity in Qty row, (File attached)
It shows error in "K" Cells (#VALUE!) & those cells which
Qty Column are not blank does not show error. (I want,
without Qty, Cells should remain blank) [....]
|Download: http://www.excelbanter.com/attachment.php?attachmentid=891|

Perhaps:

=IF(E15="","",E15-F15-G15-H15)

That presumes that E15 is empty or it has a formula that returns the null
string (""). It is not obvious that is the case based on your screenshot.
The devil is in the details.

If that does not solve your problem, I suggest that you post the URL of an
example Excel file (not just a screenshot) that has been uploaded to a
file-sharing website. Perhaps you can create a ExcelBanter attachment; I
don't know. If not, the following is a list of some free file-sharing
websites; or use your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFire: http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidShare: http://www.rapidshare.com

 

[rei.T]

You Can Also Use Iferror
Same Way As What Khanjee Suggest
=iferror(e15-f15-g15-h15.""

+-------------------------------------------------------------------
+-------------------------------------------------------------------