Current location - Health Preservation Learning Network - Fitness coach - EXCEL values retain integers, but decimals that are not shown in the calculation formula will also be counted. How can decimals not participate in the calculation?
EXCEL values retain integers, but decimals that are not shown in the calculation formula will also be counted. How can decimals not participate in the calculation?
=int(a 1)+int(a2)
Int means to keep integers and lose decimals.
By the way: the formula of rounding
Round () rounding
Roundup () enters a place unconditionally.
Rounddown () unconditionally discards values after decimal point = int ().