Excel formula de calcul

229 viewsIntrebari
0

=IF(OR(ISNUMBER(SEARCH(C152;\'[EVIDENTA FACTURI AN 2019.xls]Total Facturare\’!$B$6)));\”OK\”; \”Ne Facturat\”)

am aceasta formula ce vreau sa imi compare doua tabele, problema este ca la column imi merge pana la radul 33 dupa imi zice “More arguments have been specified for this function than are allower in the current file format

Answered question
0

=IF(OR(ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$6));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$7));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$8));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$9));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$10));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$11));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$12));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$13));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$14));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$15));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$16));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$17));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$18));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$19));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$20));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$21));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$21));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$22));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$23));;ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$24));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$25));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$26));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$27));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$28));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$30));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$31));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$32));ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$33)));”OK”; “Ne Facturat”)

Answered question
0

O formula are un numar limitat de caractere, care pot fi introduse.

Incearca ceva de genul:

=IF(ISNUMBER(SEARCH(C152;'[EVIDENTA FACTURI AN 2019.xls]Total Facturare’!$B$6:$B$33))

Se pot gasi solutii si alte solutii…

Answered question
0

Cod Proiect

O00393

P38308

C39589

Cod proiect

T94260

T94864

deci am doua coloane unde trebuie sa compar daca proiectul numit cu T94260 exista si in coloana cealalta atunci la sfarsit sa imi zica ca “OK” daca nu il gaseste atunci sa imi zica ca nu este facturat, sunt doua tabele mai exact unul unde se introduc date derspre proiect si celalalt unde sa introduce factura ideea e vreu o comparatie intre cele doua tabele pentru a nu mai cauta daca este sau nu facturat ce excel sa le gaseasca deci plecat de la o formula de comparatie

Answered question
0

tabel

Answered question
0

mai exact astea sunt tabelele

Answered question