I think this is what you wanted...

If A*G <0.5: If A*GL, then display L, else display A*G

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

What happens if A14*G14 is greater than 0.5?
--
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