IF 'x' is greater than 'y'%

[JakeMann]

Hello,

Can anyone help with an IF statement query.

Column A Column B Column C Column D
Required Received balance IF statement needed
2000 1780 -220
2000 2050 50

Assuming the 2000 under required is in A2, the 1780 in B2 etc, I am looking for a formula that says -

if the value in C is 10% less than the value in A, then return 0, if it's over 10% then return the figure in column C


Any ideas...?

[Pepe Le Mokko]

Perhaps

=IF(C2<=0.9*A2,0,C2)

[JakeMann]

Thanks Pepe