Creating Hidden value

Hi there I need assistance in how to write an expression for a hidden value. Values are to be assigned for calculation based on the number of persons in a household.

There is the question of how many persons are in the household. The following values are assigned for subsequent calculation:

1 person in the household - 1
2-4 persons in the household - 3
5 or more person -5

can you give direction on how to write the expression please

Hi,

You can use an if() function to express these kinds of conditionals.

-Clayton