If Formula For Text, What Do I Need To Change?

[rockyw]

I'm using this for numbers right now, if I'm looking for text it will not work. What would need changed for text? Thanks for any help.

=IF(T20=0.0082,5.2554,IF(T20=0.0085,5.4248,IF(T20=0.0084,5.3683,"")))

 

[Firefly2012]

Please show what you currently have (that doesn't work) - the same principle can be used for text so without seeing what isn't working it is difficult to advise.

 

[rockyw]

I have this right now..

=IF(H20=MMKL,16.50,IF(H20=MMKT,17.50,IF(H20=MMNY,18.50,"")))

H20 is a merged group (H20-M20) Is that messing it up? And also the result will be a cost, $18.50 ect

 

[Jonmo1]

You need quotes around Text Values
=IF(H20="MMKL",16.50,IF(H20="MMKT",17.50,IF(H20="MMNY",18.50,"")))

 

[rockyw]

Works great, I remember reading that some where now. Thanks for the help.