Set Minimum for Round Function outcome

[AJ86]

Hello Everybody,

This is my first post in this forum,

I hope everybody is doing well

I have a small problem,

I am trying to set the minimum outcome for this "=ROUND(F2/250,0)" to be 1 and not 0 whenever I enter a number less than 125 in the F2 cell.

Thank you!

[Pete_UK]

Use this instead:

=MAX(1,ROUND(F2/250,0))

Hope this helps.

Pete

[rcm]

Since the cutoff is .5 (125/250) the round function returns 0 add 1 to the equation but you will get 2 if f2 is 125 or higher

[bebo021999]

Nevermind......

[AJ86]

Thank you very much Pete, it worked perfectly.

Big thanks to everybody else who replied as well.