Conditional IF's

Hi,

I have a sheet which I need to apply different formulas in one column depening on the value in another column (which range from 1 to 100)

At the moment I have done this with something like
=if(A=1, formula#1, if(A=2,formula#2, if(A=3,formula#3,...etc
and then copy it down for the whole column

is there an easier way of producing this?

Thanks in advance!

Hi,

With how many conditions are you dealing ...?

Carim

about 100 different conditions...

what I'm looking to do is if a=1 increase B by x%, if a=2 increase B by y% etc up to maybe 100 or so.

Hi,

Take a look at solution provided by Chip to exceed the limit of 7 nested Ifs

http://www.cpearson.com/excel/nested.htm

HTH
Carim