If you really want to make it fool proof then I would use data
validation and conditional formatting.

For data validation first select all the QTY cells in column F, then go
to data validation, in the "Allow" menu select "Custom" and in the
formula box type: =ISNUMBER(F16) where F16 is the first cell in the
selection, next click on the "Error Alert" tab and leave a message for
the user explaining that no text is allowed, this message will appear
whenever someone tries to enter text in the cell.

For conditional formatting I would do something like this, select all
the QTY cells again and go to Format/Condtional Formatting, in the drop
down menu you have "Formula is" and "Cell value is", select "Fomula is"
and type =ISNUMBER(D16) click on format and choose a color for the
background, that way whenever a price appears in D16 F16 will be
highlighted drawing the attention of the user to that cell.

That in conjunction with your formula should make it easier for the
user.

HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=508628