Forum Discussion
Solved
Calculate value of a cell based on the 'text value' assigned on other cells
Hi, I'd like to be able to calculate the value of cells in a column based on the what has been selected on other columns. Each item has a starting numerical value (column be), that value should be m...
I inserted a row with the coefficients at the top.
Thanks for the reply, the formula doesn't seem complete. If I apply this formula the different coefficients won't be applied to the initial starting score. Is there a way I can have the starting score multiplied by the different coefficient when the value in the relevant cell is 'yes'?
I inserted a row with the coefficients at the top.