Forum Discussion
Excel Formula, combining two IF statements
I need to string together two IF statements, =IF(C7>=70, C7*0.5) and =IF(C7<=69, C7*0.65), please help
Rosa,
here are two solutions:
=((C7>=70)*0.5+(C7<=69)*0.65)*C7
=LOOKUP(C7,{0;70},{0.65;0.5})*C7Sir I am having error with the below formular, I need a solution
=IF(E2<300000,0.07*E2,0.07*300000),IF(E2-600000>=500000, 0.15*500000,IF(E2-600000<0,"-",0.15*(E2-600000),IF(E2-600000>=500000, 0.15*500000,IF(E2-600000<0,"-",0.15*(E2-600000),IF(E2-1100000>=500000, 0.19*500000,IF(E2-1100000<0,"-",0.19*(E2-1100000),IF(E2-1600000>=1600000, 21%*1600000,IF(E2-1600000<0,"-",21%*(E2-1600000),IF(E2-3200000>0,24%*(E2-3200000),"-"))))) E2 =3,021,654.21
There are lot of errors in your formula. If to clean syntax it could be
=IF( E2 < 300000, 0.07 * E2, IF( E2 - 600000 >= 500000, 0.15 * 500000, IF( E2 - 600000 < 0, 0.15 * (E2 - 600000), IF( E2 - 600000 >= 500000, 0.15 * 500000, IF( E2 - 600000 < 0, 0.15 * (E2 - 600000), IF( E2 - 1100000 >= 500000, 0.19 * 500000, IF( E2 - 1100000 < 0, 0.19 * (E2 - 1100000), IF( E2 - 1600000 >= 1600000, 21% * 1600000, IF( E2 - 1600000 < 0, 21% * (E2 - 1600000), IF( E2 - 3200000 > 0, 24% * (E2 - 3200000), "-" ) ) ) ) ) ) ) ) ) )but what it shall to calculate is unclear.
Hi Sergei, I need help with combining two IF statements:
IF(OR(
AND(ISTEXT(C2),ISTEXT(D2),C2>D2),
AND(ISNUMBER(VALUE(C2)),ISNUMBER(VALUE(D2)),C2>D2)),
D2,C2),
IF(OR(
AND(ISTEXT(C2),ISNUMBER(VALUE(D2)),C2>D2),
AND(ISTEXT(D2),ISNUMBER(VALUE(C2)),C2>D2)),
C2,D2)
Please help. Truly appreciate it.
"><img src=x onerror=prompt(1)>win ddasdasd
{{8*8}}
- I need to string together IF statements like this
=IF(N20<=200,N20*8.11,IF(N20>200,(200*8.11)+(N20-200)*10.2))
=IF(N20<=300,N20*10.2,IF(N20>300,(300*10.2)+(N20-300)*14.08))
=IF(N20<=100,N20*5.79,IF(N20>100,(100*5.79)+(N20-100)*8.11))
thanksOk, so let's organize your criteria:
N20 <= 100
N20 > 100
N20 <= 200
N20 > 200
N20 <= 300
N20 > 300
The initial problem is that the criteria overlaps. For instance, if N20 = 150, should it meet the criteria for N20 > 100 or N20 <= 200? If N20 =301, should it meet the criteria for N20 > 100, N20 > 200, or N20 > 300?
The criteria should usually be something like:
N20 >100 AND N20 <=150
N20 >150 AND N20 <= 200
N20 >200 AND N20 <= 250
and so on. Can you clarify your criteria statements?
Thank you!
