S
Siper1
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)))
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)))