Trying to make a fool proof pricing sheet - if there is such a thing

Price = D16
Suggest = E16
Quantity = F16
Total = G16

Here is my current If Statement:
=IF(F160,D16*F16,"")

This seems to be working fine until today someone typed in "text" into
the QTY Field. How can I change the if statement to not include the
text?

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