Single Question different scoring

Dear Kal_Lam,
How can I calculate the below questioner during data collection?

Q1: The source of income has been lost due to Covid-19: Score will be 5
Q1: The source of income has been temporarily closed or reduced due to Covid-19: Score will be = 3

looking forward to your kind support
Best Regards
Palash.

Hi @PALASH9698

You can achieve that by using If function. Kindly have a look at the example below.


Calculation_example.xlsx (14.3 KB)
Let me know if you need any help.
Best,
Yasser

2 Likes

Thanks a lot for your kind support.

3 Likes