Problem with an IF formula

Hi. I'm looking for a formula that does the following:

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

I tried this

Please Login or Register  to view this content.

but it says there is a problem.

Thanks for any help!
P.S. I have posted this problem also here http://www.mrexcel.com/forum/excel-q...ml#post4400237

There is something odd in your formulas how can C4be larger or smaller than itself multpiled by anything different than 1 ? (c4>=0.5*$c$4)

In addition to Pepe Le Mokko's observation about the value of C4 your formula is combining ODD and ROW into one. They should be ISODD(ROW()). There should also be an extra ) at the end of the formula.

Formula:

Please Login or Register  to view this content.

This will return a value but am not sure if it is what you are really wanting to calculate.