I want ROUND(fieldname294/120) calculation value is 1 when the actual calculation value is 0.0833. how can i get the result 1 ?
Hello @arnab28
Please, use the CEIL operation instead of the ROUND one: CEIL(fieldname294/120)
Best regards.
Hello,
I am using a checkbox there are three values are there.
but i want to use IF(ReprocessMethodSter=1,0.01,IF(ReprocessMethodDHLD=1,0.015,IF(ReprocessMethodSHLD=1,0.025)) formula.
can you tell me how can I use this formula?
Hello @arnab28
I’m sorry, but I don’t understand your formula. Who are ReprocessMethodSter, ReprocessMethodDHLD, and ReprocessMethodSHLD?
Please, send me the link to the form, and indicate the field’s name.
Best regards.
I am using a check box there are three value
1.ReprocessMethodSter
2.ReprocessMethodDHLD
3.ReprocessMethodSHLD
Hello @arnab28
A checkbox accepts you select multiple choices at once. However, your formula does not consider this situation.
Your formula would work for radio buttons where only one choice can be selected at once.
So, assuming it is a radio button with field’s name: fieldname1, the equation would be:
IF(fieldname1=='ReprocessMethodSter',0.01,IF(fieldname1=='ReprocessMethodDHLD',0.015,0.025))
Note that check by the third alternative is unnecessary.
Best regards.
but in my form, I need to select multiple options. is it possiable any solutions whre i select two option but value will show only minimum value.
for example
1.ReprocessMethodSter – 2.5%
2.ReprocessMethodDHLD – 1.5%
3.ReprocessMethodSHLD -1%
if i selected 1 and 2nd option then result show only lowset value for those two.
Hello @arnab28
Yes, of course. In this case, you should untick the checkbox: “Merge ticked up options” in the settings of the checkbox field. Now, the field’s value would be an array with the values of ticked choices. And the equation associated with the calculated field would be similar to:
IF(IN('ReprocessMethodSHLD',fieldname1),0.01,IF(IN('ReprocessMethodDHLD',fieldname1),0.015,IF(IN('ReprocessMethodSter',fieldname1),0.025, 0)))
Best regards.
Thanks for the reply, just a conformation about the formula instaed of fieldname1 can i use fieldname1_cb0,fieldname1_1_cb1,fieldname1_1_cb2 fields?
IF(IN(‘ReprocessMethodSHLD’,fieldname1),0.01,IF(IN(‘ReprocessMethodDHLD’,fieldname1),0.015,IF(IN(‘ReprocessMethodSter’,fieldname1),0.025, 0)))
Hello @arnab28
No, you must use fieldname1.
Best regards.
Hello sir,
for my input sheet form if i enter some value and remove then again if i put some value over there then value will not match the previous equation, is there anything i want to chnage?
Hello @arnab28
I’m sorry, but I don’t understand your question.
Best regards.
