Conditional Formatting and Smileys!

Thanks,

I had formatted the smileys so their was no manual input

If I wanted to add another greater than less than to that formula how would it look?

=IF(A1="","",IF(A1<10,"L",IF((A1<20,"K","J"),IF(A1<40,"K","J")))

This gives me errors.

Also are their another smiley for Excel otherr than 3 in wingdings?

birdoo2,

Sample formula (just keep chaining ifs):
=IF(A1<10,"less than 10",IF(A1<20,"between 10 and 20",IF(A1<40,"between 20 and 40","greater than 40")))

As far as other smiley faces go, I don't know of any, sorry

~tigeravatar

Your formula shows 2 brackets after the third if statement.
No more smileys but lots of other colours to use.

Hi Tigeravatar and Barrytsl,

This is still not working for me. In the formula Tiger presents the "K" is not accounted for.

I need to run the If function but instead or true or false values being applied I need 3 outcomes.

Thanks

birdoo2

birdoo2,

The K is being accounted for, but it will only display if the number is between 10 and 20:
=IF(A1="","",IF(A1<10,"L",IF(A1<20,"K","J")))

So if A1 is blank, the formula result is blank, and formula exits
If A1 is not blank and below 10, then the formula result is L and formula exits
If A1 is not below 10, but below 20, then the formula result is K and formula exits
Else formula result is J

~tigeravatar