Error with function IF----VERY IMPORTANT

[imoratal]

I have an error and I don't know the solution:

Sum(If(A='1' and B='2',C/2),(A='1' and B='3',C/4))

[#2]

Your second condition needs to be a new if

Sum(if(A='1' and B='2',C/2, if (A='1' and B='3',C/4))

[imoratal]

I have the error again. My function is:

Sum

(If(ApartadoVta='M2' and Calidad='2',([Cantidad Pedido]*CosteUnitario/2), If(ApartadoVta='M2' And Calidad='3',([Cantidad Pedido]*CosteUnitario/4

))

[imoratal]

Sorry is this:

Sum(If(ApartadoVta='M2' And Calidad='2',[Cantidad Pedido]*CosteUnitario,0), If(ApartadoVta='M2' And Calidad='3',[Cantidad Pedido]*CosteUnitario,0))

[#5]

missing closing bracket, use code and /code enclosed in square brackets [] to make formulas easier to read.

[#6]

Sorry, it not the final closing bracket but you need to remove the closing bracket on the first line

if ( <condition>, <true>, <false>)
<false> can again be a full if, if( <condition>,<true>, if (<condition>,<true>,<false>))

Usually when you get a null value (standard display is "-") from formulas it is a broken syntax.

[martin59]

Why have you created a second post ?

You have the same answers here :

Utilizar función IF DUDA

[imoratal]

Sorry Martin, I had not answers but the solution are the brackets. Thanks you