Nested IF with three conditions

[danwoltrs]

Hi guys, I'm making a spreadsheet to calculate whatever is being spent at home with my brothers so it is to be shared equally.

We are three, and I made a checkbox for each one, where when pressed the total amount will be divided equally, so if one was not there, he will not have to pay for that later on...

I made a column to check if the checkbox is active or not, so if checked it will be true, unchecked false, the cells are next to the checkboxes.

I could do a percentage, for instance on cell c10 I place: =IF(A10=TRUE,$C$7/2,0)

but then I need to check if A11 is also true, then C11 will be divided by two too, but if A12 is true, then all of them needs to be divided by three... is that even possible?

[Special-K]

Try
in B10
=IF(A10=0,0,C$7/(A$10+A$11+A$12))
and copy down the column

[danwoltrs]

Try
in B10
=IF(A10=0,0,C$7/(A$10+A$11+A$12))
and copy down the column

Thanks man, that guided me to what I needed to do :D

What I did was make the cells A10 to A12 true or false based on the checkmark.
Cells D10 to D12 =IF(A10=TRUE,$C$7,0)
Cells C10 to C12 =IF(D11=0,0,(C$7/(D$10+D$11+D$12)*$C$7))

that did the trick, thank you very much