Hi there
I'm trying to do an if formula to say, for example, if q1 from the microsoft form is 'yes', then put the number 5 in this box, and if no, put 0.
Does anyone know the best way to do this?
Solved! Go to Solution.
@smather One way to do it is to add an integer variable then use a Switch control to set the variable to a number depending on the answer to the question in the form. For example:
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
@smather One way to do it is to add an integer variable then use a Switch control to set the variable to a number depending on the answer to the question in the form. For example:
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
That's perfect @RobElliott -- sorry to bother again, but do you know how to add up these variables too?
User | Count |
---|---|
95 | |
39 | |
25 | |
22 | |
16 |
User | Count |
---|---|
129 | |
51 | |
48 | |
35 | |
24 |