You could do this:

=IF(B42<0.02,5,10)*B42

but obviously you can't put the formula in B42 itself.

Hope this helps.

Pete

On Jul 28, 1:18*am, Jules wrote:
this is the logic I need put into a formula * *
If B42 < 2%, multiply it by 5. If = 2%, multiply by 10