How do I put quotation marks ("") in an IF/THEN Function

[troyt]

I have an IF/THEN function that looks to a cell that is populated by a dropdown list that contains inch marks ie 1/4" , 3/8", etc. The problem is that when the value of the cell is added into the function, the " mark screws up the function and it doesn't work.

I don't need these values to be numeric as they are just "switches" to trigger different data sets.

I have done a work-around by populating the list with decimal equivalents and making a custom cell format that converts them to fractions and then adds the ", but the dropdown has to show the decimals and not everyone using this spreadsheet can be trusted to know how to convert to fractions.

How can I have the list populated with text ending in " and not have it mess with the function?

[troyt]

An example:

=IF(A1="1/4"","Cool","Not Cool")

the second " is messing with my function

[shg]

=IF(A1="1/4""", "Cool", "Not Cool")

Please read the forum rules about thread titles before posting again, troy.