Or put em in the same cell by using + between or use a lookup
table.

--
Don Guillett
SalesAid Software

"SyntaxError" wrote in message
ups.com...
I know that Excel states that you can only nest 7 If Statements. But I
had to make a formula that compared up to ten numbers.

After a few days of thinking I came up with this idea.

Where my formula was on the last (7th) of the IF STATEMENT, instead of
doing a calculation, I made it refer to another cell.

That particular cell then just continued my IF STATEMENTs until I had
all the calculations figured out.

By doing this you can actually have an unlimited amount of if
statement all rolled into one.

I hope this idea can help others out there. Just passing on a good
idea.