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

=IF(AND(ISNUMBER(F16),F160),D16*F16,"")

--
Regards,

Peo Sjoblom

Portland, Oregon




"streetboarder"
wrote in message
news:streetboarder.22qroy_1139118301.0945@excelfor um-nospam.com...

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

Try something like:

=IF(ISNUMBER(F16),D16*F16,"")


HTH
JG


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

Awesome - Thanks guys.

Josh


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=508628

making a fool proof sheet can be very testing.....i would data validate that
column for
either whole or decimal numbers say 1 to 10000
--
paul
remove nospam for email addy!



"streetboarder" wrote:


Awesome - Thanks guys.

Josh


--
streetboarder
------------------------------------------------------------------------
streetboarder's Profile: http://www.excelforum.com/member.php...o&userid=30707
View this thread: http://www.excelforum.com/showthread...hreadid=508628

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

Don't quite get the point.
Isn't that what you are saying in your formula?

If F16 is NOT an number OR if it is ZERO, display "please enter #".

Hans

Perhaps this would be better for you

=IF(ISTEXT(F16),"please enter #",D16*F16)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508628