why is excel for mac rounding up my numbers

For a better experience, please enable JavaScript in your browser before proceeding.

And have used it on occasion; I think it will perform what you ask.

Original message(s) as is captured: I recently developed a spreadsheet that calculated some pressure settings for a machine I was working on.

The pressure gage read in 50 psi increments, but the spreadsheet output was rounded to the nearest 1 psi.

So I developed an equation that will round to the nearest set value, being any number, interger or otherwise.

It is as follows: the number you want to round RN the number to round to INT take the interger part Rounded Up Number INT((RN)0.5) RN Rounded Down Number INT((RN)-0.5) RN Basically, take your number, and divide it by what you want to round to, RN.

Rounding to the nearest 20, is it possible Hi, I have an offset match formula.I have a value of 137 to match against 120 140 in the row, but how do I set the rounding formula to pick up the nearest (ie.

I decide to round down or up, can this also work At the moment if I round it gives me 130, but it wont match to anything as theres no 130, only 120 140.

In cell A2 if the value A then allow both positive and negative integers.

Why Is Excel For Mac Rounding Up My Numbers