Formula Help

[texastomass]

Help !!

Basically i need a formula which does the following.

If k2=Yes then c2-d2 ,and if k2=yes and L2=yes then c2-d2-e2 , and if k2=yes and L2 = Yes and M2 = Yes then c2-d2-e2-f2.

Sorry about the poor explanation but im unsure how to describe it

Thanks In Advance

 

[barry houdini]

Perhaps try

=C2-IF(K2="Yes",D2)-IF(L2="Yes",E2)-IF(M2="Yes",F2)

 

[VoG]

Try

=IF(AND(K2="Yes",L2="Yes",M2="Yes"),C2-D2-E2-F2,IF(AND(K2="Yes",L2="Yes"),C2-D2-E2,IF(K2="Yes",C2-D2,"")))

 

[T. Valko]

Help !!

Basically i need a formula which does the following.

If k2=Yes then c2-d2 ,and if k2=yes and L2=yes then c2-d2-e2 , and if k2=yes and L2 = Yes and M2 = Yes then c2-d2-e2-f2.

Sorry about the poor explanation but im unsure how to describe it

Thanks In Advance

Maybe this...

=IF(K2="yes",IF(L2="yes",IF(M2="yes",C2-D2-E2-F2,C2-D2-E2),C2-D2),"")

 

[texastomass]

Thanks guys worked perfectly !!