Nesting if functions
 

I have a spreadsheet which was in Excel 97 (I think) but I now have
Excel 2007 on my laptop.

I need to nest lots of if functions (more than 6). So I saved it into
Excel 2007 format as it was coming up with an error. However, its
still saying that I am trying to nest too many functions. I am trying
to add the seventh.

Can someone please help - as am a bit confused and not really used to
Excel 2007 yet.

Thanks in advance.

Nesting if functions
 

Are you sure that you saved it as Excel 2007, rather than still being in
2003 compatibility mode? Try closing it, and reopening the Excel 2007 file
(presumably .xlsx).
--
David Biddulph

"Louja" wrote in message
...
I have a spreadsheet which was in Excel 97 (I think) but I now have
Excel 2007 on my laptop.

I need to nest lots of if functions (more than 6). So I saved it into
Excel 2007 format as it was coming up with an error. However, its
still saying that I am trying to nest too many functions. I am trying
to add the seventh.

Can someone please help - as am a bit confused and not really used to
Excel 2007 yet.

Thanks in advance.

Nesting if functions
 

Post your formula

"Louja" wrote:

I have a spreadsheet which was in Excel 97 (I think) but I now have
Excel 2007 on my laptop.

I need to nest lots of if functions (more than 6). So I saved it into
Excel 2007 format as it was coming up with an error. However, its
still saying that I am trying to nest too many functions. I am trying
to add the seventh.

Can someone please help - as am a bit confused and not really used to
Excel 2007 yet.

Thanks in advance.

.