Excel 2007 : Significant Loss of Functionality Error

**Lungfish** · 02-22-2009, 08:56 AM

Hi, I am trying to save one of my spreadsheets to an earlier version of Excel.
When saving it gives me an error 'Significant Loss of Functionality'
Followed by : 'Some of the Formulas have more levels of nesting are supported by the selected file format.

It seems to be only one formula in the workbook and the formula is as follows:

=IF(H3=0,H2,IF(H2>0,H3,IF(H3>0,H4,IF(H4>0,H5,IF(H5>0,H6,IF(H6>0,H7,IF(H7>0,H8,IF(H8>0,H9,IF(H9>0,H10,IF(H10>0,H11,IF(H11>0,H12,IF(H12>0,H13))))))))))))

Each Cell from H2 to H13 will display the monthly account balance from that particular months spreadsheet.
The Formula (H14) is supposed to show the monthly total $ as the account balance varies from Jan-Dec. I only want the Current month to display when it varies from the previous months balance. (Progressive account total month by month) .

Each cell from H2-H13 displays blank when the Month's balance is 0.

If I save the workbook without changing, I get #VALUE Error in Cell H14.

Thanks in Advance,
Martin

**shg** · 02-22-2009, 09:45 AM

Try this array formula, which must be confirmed with Ctrl+Shift+Enter rather than just Enter:

=IF(H3=0, H2, INDEX(H3:H13, MATCH(TRUE, H2:H12>0, 0), 0) )

**Lungfish** · 03-05-2009, 07:13 AM

Hi, shg , thanks. sorry for the long time to reply but the formula work for H2, H3 but when it comes to H4 the formula does not update in H14. H14 stays as the value in H3.

I've attached the work book to try and clarify what I am doing.

Look in the monthly totals sheet...

Cheers in advance

Martin