Enter number in cell based on which checkbox is checked

llambert39581

I'm new at this so patience is appreciated.

I want to fill a cell with 2%, 4% or 6% based on one, two or three checkboxes. If checkbox Credit 1 Complete is checked, Credit Obtained = 2%; Credit 2 complete, Credit Obtained =4%; and Credit 3 complete checked, credit obtained =6%. Credit Obtained cannot be 6% without the other two boxes being checked. Any suggestions on how to write a formula for this?

Thank you!

Kelly Moore

Hey @llambert39581

When writing an IF statement for a sequential process, start at the end of the process and work backwards.

=IF([Credit 3 complete]@row=1, 0.06. IF([Credit 2 complete]@row=1, 0.04, IF([Credit 1 complete]@row=1, 0.02)))

Will this work for you?

Kelly

Kelly Moore

Hey @llambert39581

When writing an IF statement for a sequential process, start at the end of the process and work backwards.

=IF([Credit 3 complete]@row=1, 0.06. IF([Credit 2 complete]@row=1, 0.04, IF([Credit 1 complete]@row=1, 0.02)))

Will this work for you?

Kelly