If you want to use an If statement:

=IF(B4/B5=160,160,round(B4/B5,0))

--
Data Hog


"Carrie" wrote:

I'm not sure if I'm using the right formula but this is what I need:

I need the the total of b4/b5, if that equals 160 or more I need it to show
160, if it's 159 or less I need that value to show.

Thanks