A formula to get a minimum quantity in a formula

[alisag]

So I'm trying to create a formula that lets me round up my lowest value to 6. I tried an IF statement (IF(Numerical Value)<=6, "6") which works but there are two problems. 1) the "6" is not recognized as a number so I can't do a total 2) for my numbers, that are great than 6 I get an error message. I essentially want my formula to round any number less than 6 to 6 while maintaining anything greater than or equal to 6. Hope this makes sense.

 

[njimack]

=max(a1,6)

 

[Marcelo Branco]

Welcome to Mr Excel

Try something like this MAX(Numerical_value,6)

So, assuming A2 houses the numerical value
=MAX(A2,6)

Hope this helps

M.

 

[alisag]

ok that was ridiculously easy! thank you!! One more question, and I should have specified- Less than 6 but greater than 0. Anything that is 0 I want to it to stay as is.

 

[njimack]

=if(a1=0,0,max(a1,6))

 

[alisag]

Fabulous! Thanks so much Neil!