% in IF Formula Help please

[skylinegtr]

Hi
Could someone please help me with the following issue

I have this formula:

=IF(Y2="","",IF(Y2<Z2,Z2,Y2+AB2))

I want to change it so the first Z2 comparison is actually 50% of Z2.
I have tried
=IF(Y2="","",IF(Y2<(Z2*0.5),Z2,Y2+AB2))
=IF(Y2="","",IF(Y2<Z2,(Z2*1/2),Y2+AB2))

But they dont work, they give a different number but the calculation is wrong.
How can I say 50% of Z2 in that IF Statement? I dont want a new column or anything!

Thank you in advance

[arthurbr]

Hi
better post a small sample with the problem, looks all right at first glance