Round Figure If

[Velven]

Hello !


I would like to round a figure example based on the number.

Such as
3.4 Will be 3.
3.5 will be 3.
3.6 will be 4.

How do I do so ?

 

[steve the fish]

If you round up 3.4 how do you come to the answer being 3?

 

[Velven]

If you round up 3.4 how do you come to the answer being 3?

Thanks for pointing that out. Didn't notice it.

I meant to round the figure.

Anything 3.5 or below will be 3.
Anything above 3.5 will be 4.

 

[Paul Ked]

If the number to be rounded is in A1 then

=IF(A1-int(A1)>0.5,int(A1)+1,int(A1))

 

[steve the fish]

The ROUND function virtually does that. Normally when rounding 0.5 will get rounded up not down but here is a way for it to be rounded down:

=ROUND(A1-0.00000000000001,0)

Rounded as normal rules its just:

=ROUND(A1,0)