If, Then formula - Multiple levels
 

Hi,
I need a way to create a formula that basically says:

if cell1 = x, then use [this set of nested if/then statments]
if cell1 = x2, then use [this set of nested if/then statments]... and so
on...
I have 8 different sets of nested if, then formulas that are dependent on
what the cell is...

If, Then formula - Multiple levels
 

You don't give us a lot of detail, but maybe this link will be useful
to you:

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

Hope this helps.

Pete

CPROULXM wrote:

Hi,
I need a way to create a formula that basically says:

if cell1 = x, then use [this set of nested if/then statments]
if cell1 = x2, then use [this set of nested if/then statments]... and so
on...
I have 8 different sets of nested if, then formulas that are dependent on
what the cell is...