Trying to avoid nested IFs
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
|