AND Function with checkboxes

[Adhil061]

Hi,

I am using this formula for calculation based on two check boxes.
F3 and F4 are the checkboxes.

=IF(F3=TRUE,AND(F4=FALSE)*SUM(D2+G3+D4),IF(F4=TRUE,AND(F3=FALSE)*SUM(D2+D3+G4),IF(F3=TRUE,AND(F4=TRUE)*SUM(D2+G3+G4),SUM(D2:D4))))

Everything works fine except when both are true i don't get the value, instead i get 0. where am i wrong

Please help.

 

[bebo021999]

How about:

=D2+IF(F3,G3,D3)+IF(F4,G4,D4)

 

[Adhil061]

How about:

=D2+IF(F3,G3,D3)+IF(F4,G4,D4)

Thanks my friend. It worked perfectly
??