If Formula - Help
"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.
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.
|