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 it appears in the cell, but the calcul of the formula is not happening
table "result" :
criteria 1 - criteria 2 - My cell
table database
column A : combinaison of criteria 1&2= 32 differentes lines
column B : 32 lines corresponding to 32 differents formula to apply in my cell depending on criteria 1&2 combinaison
so my formula was:
RECHERCHEV(CONCATENER([@criteria1];[@criteria2]);Tableaudatabase;2;FAUX))
(sorry my formula is in french)
but with this formula, my formula appears as a text and isn't calculated
which fonction do i use to make so my formula is calculated?
thanks to helpers + sorry for bad english
21 Replies
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?
