Simple Formula Help?
 

I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))

Simple Formula Help?
 

hi
try this....
=IF(AND(K12="Yes",D12="Yes"),C12*0.7,IF(AND(K12="Y es",D12="No"),C12,0))

regards
FSt1

"Siper1" wrote:

I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))

Simple Formula Help?
 

=IF(K12="NO",0,IF(D12="N",C12,0.7*C12))

--
Gary''s Student - gsnu200749


"Siper1" wrote:

I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))

Simple Formula Help?
 

See if this does what you want...

=IF(K12="yes",IF(D12="yes",0.7*C12,C12),0)

If K12 is "no" or ANY OTHER text not equal to "yes", the formula returns 0.

Rick


"Siper1" wrote in message
...
I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))

Simple Formula Help?
 

=IF(K12="yes",IF(D12="yes",0.7,1))*C12


"Siper1" wrote:

I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))

Simple Formula Help?
 

Ah yes, use the multiplication to transform the FALSE to zero... nice. Here
is a 2-character shorter formula built around the same idea...

=(K12="yes")*(1-0.3*(D12="yes"))*C12

Rick


"Teethless mama" wrote in message
...
=IF(K12="yes",IF(D12="yes",0.7,1))*C12


"Siper1" wrote:

I'm having difficulty with a formula and need some help.

I'm attempting to do the following:

If K12 = "no" then total = 0
If K12 and D12 = "yes" then total = C12 x 70%
If K12 ="yes" and D12 = "No" then total = C12

This is what I have:

=IF((K12="Yes",D12=Yes),(C12)*0.7,0),((IF((K12=Yes ,D12=No),(C12),0)))