Home |
Search |
Today's Posts |
#1
|
|||
|
|||
INT Function
I need the remainder results of a multiplication formula. The Function INT
should provide this results -- Excel Function Help for INT provide the formula =A2-INT . I have tried this sever times but the results is alway the same #Name... Is excel broken or what am i missing? |
#2
|
|||
|
|||
The INT() function truncates a decimal number down to it's integer part (i.e.
=INT(9.9 will return 9) This doesn't sound like the function you want to use if you're looking for remainders. Try using MOD() -- Regards, Dave "Dan (WA)" wrote: I need the remainder results of a multiplication formula. The Function INT should provide this results -- Excel Function Help for INT provide the formula =A2-INT . I have tried this sever times but the results is alway the same #Name... Is excel broken or what am i missing? |
#3
|
|||
|
|||
You need to supply a parameter to the INT function. To get the portion to the
right of the decimal, use: =a2-int(a2) You can also get the same thing in one step with the Mod function: =mod(a2,1) -- Regards, Fred "Dan (WA)" <Dan wrote in message ... I need the remainder results of a multiplication formula. The Function INT should provide this results -- Excel Function Help for INT provide the formula =A2-INT . I have tried this sever times but the results is alway the same #Name... Is excel broken or what am i missing? |
#4
|
|||
|
|||
Fred Smith wrote...
You need to supply a parameter to the INT function. To get the portion to the right of the decimal, use: =a2-int(a2) You can also get the same thing in one step with the Mod function: =mod(a2,1) .... Use the INT formula. MOD is broken when quotients are large, e.g., =2^30/3-INT(2^30/3) correctly returns 1/3 (approximately, accurate to only 7 decimal digits), while =MOD(2^30/3,1) returns #NUM!. |
#5
|
|||
|
|||
On Mon, 10 Oct 2005 11:59:09 -0700, "Dan (WA)" <Dan
wrote: I need the remainder results of a multiplication formula. The Function INT should provide this results -- Excel Function Help for INT provide the formula =A2-INT . I have tried this sever times but the results is alway the same #Name... Is excel broken or what am i missing? Actually, the formula in HELP is =A2-INT(A2) If you type in what you posted above =A2-INT you will get a #NAME? error. An alternative formula, giving the same result, would be: =MOD(A2,1) --ron |
#6
|
|||
|
|||
On Mon, 10 Oct 2005 16:03:34 -0400, Ron Rosenfeld
wrote: On Mon, 10 Oct 2005 11:59:09 -0700, "Dan (WA)" <Dan wrote: I need the remainder results of a multiplication formula. The Function INT should provide this results -- Excel Function Help for INT provide the formula =A2-INT . I have tried this sever times but the results is alway the same #Name... Is excel broken or what am i missing? Actually, the formula in HELP is =A2-INT(A2) If you type in what you posted above =A2-INT you will get a #NAME? error. An alternative formula, giving the same result, would be: =MOD(A2,1) --ron However, as Harlan just pointed out (and which he has pointed out in the past, but which I have forgotten), MOD does not work with large numbers, so INT would be safer. --ron |
#7
|
|||
|
|||
Thanks -- To all those who Help me see the errors of my ways.. So simple just
needed a kick start.. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |