View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
streetboarder
 
Posts: n/a
Default If Statement - Need Help


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