MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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<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?
Thanks in advance.
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 < 20 ----> *
etc

Care to do that?

Aladin

=======

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

Try
=IF($K$2>10,IF($K$2<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 :)