Validation is a good idea however I would like make this sheet as user
friendly as possible (since after all this is how we get our orders).
'=IF(AND(ISNUMBER(F16),F160),D16*F16,"please enter #")
I am thinking more along the lines of the above but for some reason I
can't get it to work correctly. If the cell is blank or their is a zero
in the QTY colume it returns "please enter #".
Any help would be appreciated.
Thanks,
Josh
--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile:
http://www.excelforum.com/member.php...o&userid=30707
View this thread:
http://www.excelforum.com/showthread...hreadid=508628