[ad_1]
Hi,
I would like help with the formula below:
fieldname1 = number
calculated field with numerical result from the equations below:
If fieldname1 entered is from 1 to 20 mg then multiply number entered by factor of 4. For example, if number entered is 1 then 1×4. The calculated field will show 4. If number entered is 2 then 2×4. the calculated field will show 8, etc.
If fieldname1 entered is from 21 to 40 mg then multiply number entered by factor of 8
If fieldname1 entered is equal to or greater than 41 to 60 mg then multiply number entered by factor of 10.
Thank you.