Hello, my question is quite simple. It's an excel file used to automatise the calculation of scaled score. A patient take a test on 18 items, then we get its raw score result. Lets say we write the result on the B2 cell.
I want to get the result of the scaled score on the B3 cell. Instead of writing myself in the B3 cell the if condition ( if B2=0;3;B2=1;4) etc... for every case, is there a way to just select the whole table and make it work?
If yes, with which syntax ?
Thanks everyone
I want to get the result of the scaled score on the B3 cell. Instead of writing myself in the B3 cell the if condition ( if B2=0;3;B2=1;4) etc... for every case, is there a way to just select the whole table and make it work?
If yes, with which syntax ?
Thanks everyone