mardi 1 août 2017

This formula can't be entered because it uses more than 64 levels of nesting

If i get this message of 64 levels, am i able somehow still use more than 64 if? or i need to think new formula?

Maybe someone can help me to create new?

I need to check if one cell equal to other more than 64 cells, and if it is equal i need to get different value.

For example

=IF(AJ$2=info!$AJ$2;info!$AJ3;IF(Production!AJ$2=info!$AK$2;info!$AK3;IF(Production!AJ$2=info!$AL$2;info!$AL3;IF(Production!AJ$2=info!$AM$2;info!$AM3;IF(AJ$2=info!$AN$2;info!$AN3;IF(Production!AJ$2=info!$AO$2;info!$AO3;IF(AJ$2=info!$AP$2;info!$AP3;....

i have like this table:

enter image description here

And im cheking if my other cell equal to number in table and if yes, returning sign "x" or "-". (im doing this checking for a lot of rows.

Aucun commentaire:

Enregistrer un commentaire