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