Write Function that has 2 check boxes in it?

ChuckCarothers

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!

Paul Newcome

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, "")))

ChuckCarothers

Thank you so much, Paul, that works perfectly!

Paul Newcome

Happy to help.