thanks Pete
probably that will work
split in 2 in columns
and get the max between those??
after all
the formula gets only 1 value


"Pete_UK" wrote:

Excel 2003 and earlier versions will not recognise IFERROR, so you will
probably have a #NAME error if you try to load the file on those versions.

With regard to the nesting problem, I suggest you split your formula into
smaller chunks over a few columns and then combine them using these
intermediate columns.

Hope this helps.

Pete


"Alonso" wrote in message
...
Hi Pete

You're right
I'm using Excel 2007

the reason i got the nesting error is because I save this archive in
97-2003
format
not everyone in the office has 2007, and I need that they can see the file

it's there a potencial problem with the IFERROR formula??



"Pete_UK" wrote:

You've got IFERROR in there, which implies that you are using Excel 2007,
which I thought had a nesting limit of 64 - your formula does not exceed
that, does it? (I've not looked at it in detail as I only have Excel
2000)

Pete