Hi guys,

Your officially my Excel mentors I hope you dont mind!

I am using the forumla =IF(OR(E2="COLD"),"33%")

Which kindly changes my cell to show the text 33% if the text cold is entered into cell E2. Now what I would like to know, is if I can add multiple catch words to give alternate pre defined percentages. Such as warm and hot to give the respective answers as 66% and 99%

Your help is always appriciated!