So really, only display L if A*G <0.5 AND A*G L?
=IF(AND(A14*G14<0.5,A14*G14L14),L14,A14*G14)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Scp" wrote:

Well, I'll start it to what I have so far, but I need one last improvement to
the formula to make it true, and I keep getting errors.

=IF(A14*G14<0.5,L14,(A14*G14))

I want it to multiply A x G
if the sum is less then .5 then to carry over the number from L
BUT if it's less than .5 but greater than L then to multiply it out

Thank You