I need a formula that gives me always the lowest number with decimals. So for example:
10,2 has to give me 10
10,8 has to give me as well 10 and not 11
I assume that is possible. Anybody can help me with this?
I need a formula that gives me always the lowest number with decimals. So for example:
10,2 has to give me 10
10,8 has to give me as well 10 and not 11
I assume that is possible. Anybody can help me with this?
Last edited by pansovic; 11-30-2011 at 04:19 AM.
=int(A1) .
Entia non sunt multiplicanda sine necessitate
or =Floor(A1,1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks