Then may be this in E4
=IF(OR(C4=0,C4=""),"",C4*D4) copied down
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks to previous advice I have achieved most of what I was after, I have tried all other suggestions regarding auto calculating COL B to COL C as per previous attachment with no luck.
I shall just have to enter that data manually.
Won't waste any more of your time thanks for past assistance.
Last edited by COLC; 03-24-2008 at 08:09 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks