View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alonso[_2_] Alonso[_2_] is offline
external usenet poster
 
Posts: 58
Default 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