Question

Formula in forms

Forms

Updated August 31, 2018

asked on August 31, 2018

=IF(B15 <=14,0, IF(B16<=29,5, IF(B17<=44,10,IF(B18<=59,15,IF(B19>=60,20,)))))

Can someone tell me what I am missing in this formula? I’m creating a form for a manager that wants students to receive so many points for the hours they have taken in a topic.

The breakdown is below:

If someone gets between 0-14 hours they will receive 0 points

If someone gets between 15-29 hours they will receive 5 points

If someone gets between 30-44 hours they will receive 10 points

If someone gets between 45-59 hours they will receive 15 points

If someone gets between 60 or more hours they will receive 20 points

0 0

Replies

replied on August 31, 2018

Not sure I understand what you're doing here. Why is your condition testing the value of different fields?

0 0

View 1 previous reply

replied on August 31, 2018 • Show version history

Zane makes a good point, from what you're describing it sounds like they should all be referencing the same field/variable.

What is the variable where the number of hours coming from on your form?

0 0

replied on August 31, 2018

I was creating this in Excel. She wants the form to calculate the points earned for the hours a student inputs.

So if a student inputs 1 hour they will not receive any points. If a student submits 15 hours they will get five points.

0 0

replied on August 31, 2018 • Show version history

Assuming you want this functionality in Forms and and not in Excel, you could do this as a radio button group. Each button would be labeled with your hour range, then you would assign a value of your point system. No calculation necessary.

0 0

replied on August 31, 2018

Even if you're creating this in Excel, your "hours" value should still be coming from a consistent source outside of the table. For example, the rows don't don't matter because the function has the associated values built-in and the referenced "hours" value should remain consistent for each comparison.

0 0

replied on August 31, 2018

Ill take a look back at my information and see what it is I did wrong. I see what you guys are saying.

0 0

You are not allowed to follow up in this post.

Question

Question

Formula in forms

Replies

Sign in to reply to this post.