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.

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 ----> *

Care to do that?



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

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...


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


...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 :)