Forum Discussion
how to make a cell calculate a formula of an other cell
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.
HansVogelaari made an excel sheet to explain what i need.
i'm open to new suggestion too.
translation of the french text inside :
"Hello,
I want to calculate my compliance box (yellow) automatically according to the result (variable) and according to the limits set for each combination of reference/test.
The source of the values is in the tab "sources of the formulas" and are recalled with the help of RECHERCHEV in this table for practicality.
The formula to be used for the calculation of conformity is also recalled on this sheet from the sheet "sources of formulas" and is different for each line and each result.
A big part of the work is done, but I can't manage to switch from "the cell contains a formula in text form" to "the cell calculates the formula stored in text".
Maybe it's a common syntax error, but I'm stuck at this point.
Any ideas?Thanks in advance."