Hi!
I’m trying to build an app to calculate the Nurse Activity Score.
This score is the sum of several variables (colums).
Most of the colums are enumlist or true/false type columns.
Depending on the answer given for each variable, a value (decimal number) must be assigned to that variable,
The idea is to get a total score that would be the sum of all the values assigned to the variables.
For example, the variable [monitoring] can be given 3 possible answers -----> number:
normal ----> number 4.5
more than normal .------> 12.1
much more than normal ------> 19.6
I’ve been trying with ifs function and ifs(in function but couldn’t get the syntaxis righ.
Can anyone help with a detailed way to write this formula?
Thanks!
Cecilia
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |