# Write Function that has 2 check boxes in it?

Options
edited 12/09/19

Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be.

I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working function that fills my Balance by multiplying my cost (20) * Quantity and removes the balance when the check box under Paid is checked -

=IF(Paid1 = 0, Quantity1 * 20)

So, 20 is my cost with fulfillment, but I would like to be able to check No Fulfillment when needed and it changes my cost to 18, which changes my balance and still having it removed when clicking Paid.

=IF(Paid1 = 0, Quantity1 * 20), IF(No Fulfillment1 = 1, Quantity1 * 18)

Even I am confused by how I wrote this, but can anyone help?

Thanks!

Tags:

• ✭✭✭✭✭✭
Options

So if Paid is NOT checked and No Fulfillment is NOT checked, then it would be Quantity * 20, but if Paid is NOT checked and No Fulfillment IS checked, then it would be Quantity * 18, and finally, if Paid IS checked, then leave it blank?

=IF(AND(Paid@row = 0, [No Fulfillment]@row = 0), Quantity@row * 20, IF(AND(Paid@row = 0, [No Fulfillment]@row = 1), Quantity@row * 18, IF(Paid@row = 1, "")))

• Options

Thank you so much, Paul, that works perfectly!

• ✭✭✭✭✭✭
Options

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!