# Enter number in cell based on which checkbox is checked

Options

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!

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!