| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leaing to the next full number?
How do i get a number to leaing to the next full number? Eks: 5,69 = 5 4,31 = 4 6,93 = 6 7,01 = 7 Anyone? -- S33N ------------------------------------------------------------------------ S33N's Profile: http://www.excelforum.com/member.php...o&userid=29228 View this thread: http://www.excelforum.com/showthread...hreadid=489514 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaing to the next full number?
The function you need is INT(). INT(5,69) = 5.
HTH Kostis Vezerides |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaing to the next full number?
=INT(A1)
-- Kind regards, Niek Otten "S33N" wrote in message ... How do i get a number to leaing to the next full number? Eks: 5,69 = 5 4,31 = 4 6,93 = 6 7,01 = 7 Anyone? -- S33N ------------------------------------------------------------------------ S33N's Profile: http://www.excelforum.com/member.php...o&userid=29228 View this thread: http://www.excelforum.com/showthread...hreadid=489514 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Leaing to the next full number?
That easy huh... WOW, Thanx! :D -- S33N ------------------------------------------------------------------------ S33N's Profile: http://www.excelforum.com/member.php...o&userid=29228 View this thread: http://www.excelforum.com/showthread...hreadid=489514 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number format | Excel Discussion (Misc queries) | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Linear Mode
