Hi Darin

With the limited info given, there is a way around this. Split your
arguments over two comuns, the first testing the first say 6 ifs. As a
result for If nr 6 being False, use "NOT DONE" Then in the 2nd column, test
only conditions 7 to 10, in other words the ones stating "NOT DONE". With
more info availabloe, VLOOKKUP could be an easier solution
--
ve_2nd_at. Stilfontein, Northwest, South Africa


"Darin Gibson" wrote:

I need to nest 10 IF functions.

According to Excel help:

Up to seven IF functions can be nested as value_if_true and value_if_false
arguments to construct more elaborate tests. See the last of the following
examples.

What else can I do?