Rating system to generate smileys

Hi,

I want excel to generate a smiley depending on weather the result was on budget, under or above. Basically like this:

:D = more than 5% over budget
:) = 0-5% over budget
:( = under budget

I have a chart of the budget in the sheet as well as a sheet to input the actual outcome (sales) and then I want this evaluation chart with the smileys.

I'm stuck in some infinite loop of 'IF' and 'AND's and basiclly don't know what the heck I'm doing anymore. I have no idea how to include so many IF's in one formula/cell.

Please help! This is driving me crazy..

Assuming a budget of 10, maybe:

PHP Code: 

=LOOKUP(A1,{0,10,10.05},{":(",":)",":D"}) 


That didn't do anything, bah. Let's just assume the budget is X and Y is the actual. For example when generating the smiley for "", then I need it to say something like =IF(AND(Y>=X;Y<(1,051*X));"";""). But how do I then add in the other IF's for the other smileys?

Jeff, it works! Halleluja. I love you!

New day, new problems. So I'm at it again. Now the problem I have is that when I have no data input for the smiley to evaluate, it still provides me with a ":D". I want it to leave it blank. Where and how can I add that into my formula?

Thank you,
Emma

Try this =IF(A1="";"";IF(B1>=A1*1,05;":D";IF(B1<A1;"";IF(OR(A1=B1;B1<A1*1,05);""))))

gah, Thank you!! I had written =IF(A1;"";""; Why doesn't that work?

Never mind, I got it! Too early too process correctly. Thank you so much again!!!