From Excel's help: "A formula can contain up to seven levels of nested
functions". You're well past double that. Half the nesting levels could be
eliminated by removing the ( before each 'if'. But you'd still be over the
limit.
Can you tell us more about what's in column AA? For example, can you be
certain that if a given cell is populated with a value 0, that all the
cells above it are also populated? Will they either have no value or a
number 0? ...


"ladyhawk" wrote:

Can anyone tell me what is wrong with the formula below:
=if(Data!AA910,Data!C92,(if(Data!AA910,Data!C85, (if(Data!AA780,Data!C78,(if(Data!AA710,Data!C71, (if(Data!AA640,Data!C64,(if(Data!AA570,Data!C57, (if(Data!AA430,Data!C43,(if(Data!AA360,Data!C36, (if(Data!AA220,Data!C22,(if(Data!AA150,Data!C15, Data!C8))))))))))))))))))