If formula entered too many arguments

[phil133]

Hi. In this formula I get too many arguments =if(and(b5<>"",if(mod(row(),2=1,c4>=0.5*$c$4))),i4-i5,if(and(b5<>"",if(mod(row(),2=1,c4<=0.5*$c$4))),$ah$4-(($ah$4/c4)*c5,"")

What I want is if(and(b5<>"",if(mod(row(),2=1,c4>=0.5*$c$4) give me i4-i5
If(and(b5<>"",if(mod(row(),2=1,c4<=0.5*$c$4 give me $ah$4-(($ah$4/c4)*c5
In all other circumstances give me ""

Thanks

 

[phil133]

I'm stuck and can't find the error! Does anyone know?

Thank you

 

[Rick Rothstein]

Hi. In this formula I get too many arguments =if(and(b5<>"",if(mod(row(),2=1,c4>=0.5*$c$4))),i4-i5,if(and(b5<>"",if(mod(row(),2=1,c4<=0.5*$c$4))),$ah$4-(($ah$4/c4)*c5,"")

Something looks wrong to me in the section I highlighted in red.... you have a MOD function call which looks like its closing parenthesis might be located incorrectly (at a glance, I would have expected it after the number 2).