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:
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