Percentage formulas

[Sami66]

I am having trouble with the doing a formula that satisfies the belo
problem:

Column C=beginning balance
Column E=payments
Column F=credits

If the payment is at least 12% of beginning balance, the custome
recieves a credit of 2.5% of beginning balance; otherwise they do no
recievea credit (value is 0)

Any help will be greatly appreciated!!!!!

Thanks in advance!!

 

[JE McGimpsey]

Slight improvement:

=IF(E2>=(0.12*C2),C2*0.025),0)

another way:

= 2.5% * C2 * (E2 >= (12% * C2))

 

[Sami66]

I really appreciate you taking the time to help Red.......if it is a
all convenient, ccould you please check out my other post
Thanks!!!!!!!!!