Divide and round/leave as it

[alexxnew]

I am dividing column N by 88 and would like the result in column N to round down to 1 (if over 1) and if under 1, leave the result as is.

If result = 1.62 (I need it to show 1 in column N)
If result = .54 (I need it to show .54 in column N)

This is what I have currently, but I can't figure out how to incorporate the division part:

=IF(N2>0.99,"1","")

 

[Eric W]

Welcome to the forum!

Try:

=MIN(1,N2/88)