How do I prevent the decimal value being used?

[Tusk]

How do I format a cell to prevent the decimal value from being used in calculations?

If I format the cell to "0" decimal places it still calculates with the decimal value and I only want to use the whole number in calculations, is there a way to do this?

[Paul]

Hi Tusk, welcome to the forum.

Two ways may work:

1. In your formula, don't just reference the cell, e.g. "=A1*5". Instead, use the INT() function when referencing the cell. "=INT(A1)*5"

2. Don't allow users to enter decimal values in the cell to begin with, only whole numbers. You can do this by adding Data Validation to the cell. You can set it to Whole Number and choose additional criteria if necessary (e.g. Greater Than x, or Between x and y, etc.)

[Tusk]

Thanks Paul!

The "=INT(A1)*5" is what I,m looking for

Much apreciated

[Tusk]

Paul do you know what the equivalent in Java script of "=INT(A1)" would be?

Thanks

[protonLeah]

The JavaScript floor() method rounds a number DOWNWARDS to the nearest integer, and returns the result
var MyInt = Math.floor(x)

[6StringJazzer]

Thanks Paul!

The "=INT(A1)*5" is what I,m looking for

Much apreciated

Do be aware that if you have a cell in Excel formatted for 0 decimal places, the number you see is rounded to the nearest integer, whereas in the INT function the decimal part is truncated. So if you want to do arithmetic on the number you see, you should use

=ROUND(A1,0)*5

[ChemistB]

Alternately, you could set the workbook to "Precision as displayed". Then what you see is what you get. This feature (in Excel Options) is not protected though so an individual could turn it on or off.

[Tusk]

Thanks Proton!

The JavaScript floor() method is what I am looking for much apreciated