How to stablish a minimum value on a cell?

Hi!
So I’m creating a sheet to help me make quotes easier.

One of my supplies minimum price quantity starts at 0.5m2

I’m using a LxH formula and I want the resulting cell to start at 0.5 even when the multiplication doesnt reach that amount.

I’ve searched at the best I can do and couln’t find anything.

MAX(X1;0.5) is working!

1 Like