What does the etc mean? You can have 3 conditions in
excel earlier to 2007. If you are using that then you would need code

http://www.xldynamic.com/source/xld.....Download.html

--


Regards,


Peo Sjoblom

"Spencer O." <Spencer wrote in message
...
I want to make a conditional formula with multiple variables, but I'm not
sure how (e.g. if B6<=5, display 1; if B65 but <=10, display 4; etc)