All respected fellows,

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)

Please guide me how can I resolve this.


Always regards
Desperately Waiting.

"khanjee" wrote:
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
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com

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