Using an IF function to return a minimum result

Originally Posted by philaugust2004

Try this

=IF(T14="SqM",IF(F14*G14<0.5,0.5,F14*G14),J14)

I knew it would be easy for you!
Perfect, thank you so much!