# Multiple IF function

Posted by Sasa on January 30, 2002 6:41 AM

Dear all,
I have formula =IF(\$K\$2>10,IF(\$K\$2&LT;20,"*"),"")wich works, but I would like to add one more condition something like =IF(\$K\$2>20,"**"). How can I combine this two formula into one?
Regards
Sasa

Posted by Aladin Akyurek on January 30, 2002 7:00 AM

Sasa --

You can better describe condtion by condition what you want to compute/achive like this

K2 > 10 and K2 &LT; 20 ----> *
etc

Care to do that?

=======

Posted by JohnG on January 30, 2002 7:12 AM

Try
=IF(\$K\$2>10,IF(\$K\$2&LT;20,"*","**"),"")
If its less than 20 you get "*" else if its equal or greater than 20 you get "**"

Posted by Mark W. on January 30, 2002 7:41 AM

Another approach...

You could skip the IFs and use...

=REPT("*",MIN(2,MAX(0,\$K\$2)/10))

...later if you decide to add an asterisk for
each increment of 10 you could change it to...

=REPT("*",MAX(0,\$K\$2)/10)

...which is much simplier than nesting IFs!

Posted by Sasa on January 30, 2002 7:42 AM

Thank a lot. Works fine :)))

Posted by Sasa on January 30, 2002 8:06 AM

Re: Another approach...

Thanks. Works even better !!!
Really appreciate it :)