Forum Discussion
how to make a cell calculate a formula of an other cell
Hello, so i have this issue with my table: i want my cell on the "result" table to calcul a different formula according to 2 criterias in a "database" table. i manage to rechercheV my formula so...
A formula should start with =
=RECHERCHEV(CONCATENER([@criteria1];[@criteria2]);Tableaudatabase;2;FAUX))
Does the first column of Tableaudatabase contain the combinations of the criteria without a space or other character in between?
Also make sure that the cell with the formula is not formatted as Text, but as (for example) General.
my formula did start wtih the equal sign
=RECHERCHEV(CONCATENER([@criteria1];[@criteria2]);Tableaudatabase;2;FAUX))
and it worked, as the formula now appearing is the one i wanted from the database table. but it appears as text and isn't calculated
Have you checked the remarks from my previous reply about the cell format and the Show Formulas button?
- yes, it's all rightly done
To put it simply, i need my cell A1 to calculate this text write in cell A2 :
SI([@[Résultat]]<=[@[Spec / limite sup]];"CF";"NC")
but this text is obtained by using the formula
=RECHERCHEV(CONCATENER([@criteria1];[@criteria2]);Tableaudatabase;2;FAUX))I am really sorry, but I can't visualize what you want.