Hi,
In cells D4:D13 I ask the users of this Excel sheet to type in a
thickness of material. This is a decimal followed by three digits.
Example: .250
But if they type in the inch mark after the thickness, it messes up the
formula I have in related cells E4:E13.
For example: In E4 I have
=(IF(D4<=0.225,Pricing!C2,IF((D4=0.301),Pricing!C 37,Pricing!C19)))
All is well if the user types in something like .250, but if they type
in .250" my formula does not work. I can't use drop down menus or
Lookup lists because there are an almost infinite number of
thicknesses.
Is there anything I can add to my formula to make it remove the inch
mark if one is present? Is there anther solution?
Many thanks in advance.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=539976