| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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))) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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))) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Need simple IF formula, please | Excel Worksheet Functions | |||
| Need help with a simple formula | New Users to Excel | |||
| help with simple formula | Excel Worksheet Functions | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Linear Mode
