Multiple If And Statements

[Bryker28]

I am creating a 4 payment option payment with check boxes. I set the check boxes and have come up with the following formula:

=IF(AND(D29=TRUE,D30=TRUE,D31=TRUE,D32=FALSE),E27/3,"")

This works if all 3 check boxes are checked.

The problem: I need all scenarios in each cell so the payment only shows if the box is checked.

Is it possible to do a long string of if and statements with each possible scenario?

 

[Chihiro]

Can you upload sample workbook, along with your expected output for different cases. Hard to give you right solution without looking at your workbook set up.

 

[Hui]

Your formula can be simplified to

=IF(AND(D29,D30,D31,not(D32)),E27/3,"")

Please upload a sample file