If Formula - Help

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

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
 
Carrie said:
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.
Click to expand...

Ostensibly:

=min(160, B4/B5)

But not that B4/B5 might not always be an integral value (158, 159, 160,
etc). So I wonder if you mean: if B4/B5 would __appear__ as 159 or less
when displayed in a cell formatted with zero decimal places.

In that case, you might want:

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

So if B4/B5 were 159.5 or larger, the result would be 160.
 
Back
Top