Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display answer as whole number and remainder
I wanted to be able to divide one number by another and display the answer as
a whole number (not rounded up or down) and then the remainder in separate cells so I can apply other formulas to the answers later. EG 6000 / 305 = 19 r 205 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display answer as whole number and remainder
Hi ynot
do you want to have this in VBA or as a formula? formula: a1: 6000 a2: 305 a3: =ROUND((A1-(A2/2))/A2,0) a4: =A1-A2*A3 hth Carlo "ynot" wrote: I wanted to be able to divide one number by another and display the answer as a whole number (not rounded up or down) and then the remainder in separate cells so I can apply other formulas to the answers later. EG 6000 / 305 = 19 r 205 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display answer as whole number and remainder
Sorry, correction:
(although the formula before works, this one is cleaner) a3: =TRUNC(A1/A2,0) Hth Carlo "Carlo" wrote: Hi ynot do you want to have this in VBA or as a formula? formula: a1: 6000 a2: 305 a3: =ROUND((A1-(A2/2))/A2,0) a4: =A1-A2*A3 hth Carlo "ynot" wrote: I wanted to be able to divide one number by another and display the answer as a whole number (not rounded up or down) and then the remainder in separate cells so I can apply other formulas to the answers later. EG 6000 / 305 = 19 r 205 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to display answer as whole number and remainder
You can use MOD() to find the remainder.
Tim "ynot" wrote in message ... I wanted to be able to divide one number by another and display the answer as a whole number (not rounded up or down) and then the remainder in separate cells so I can apply other formulas to the answers later. EG 6000 / 305 = 19 r 205 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert number to dozen showing remainder | New Users to Excel | |||
I need an answer display in one cell if (=), but another if (-) | Excel Discussion (Misc queries) | |||
Formulas display 0 instead of answer | Excel Discussion (Misc queries) | |||
How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
Divide number and add remainder in another cell | Excel Discussion (Misc queries) |