| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation based on decimal
Please advised on how to calculate:
I have a forecast = 39,975 I have a shift qty = 7,535 shift production requirement = 5.3 (39975/7535) What formula will determine the qty of the overage of .3 shifts? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation based on decimal
hi
=mod(39975,7535) or if 39975 was in a1 and 7535 was in b1 then =mod(a1,b1) Regards FSt1 "cjborntorun" wrote: Please advised on how to calculate: I have a forecast = 39,975 I have a shift qty = 7,535 shift production requirement = 5.3 (39975/7535) What formula will determine the qty of the overage of .3 shifts? Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation based on decimal
thank you - that does the job
"FSt1" wrote: hi =mod(39975,7535) or if 39975 was in a1 and 7535 was in b1 then =mod(a1,b1) Regards FSt1 "cjborntorun" wrote: Please advised on how to calculate: I have a forecast = 39,975 I have a shift qty = 7,535 shift production requirement = 5.3 (39975/7535) What formula will determine the qty of the overage of .3 shifts? Thank you |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculation based on decimal
glad to help. thanks for the feedback.
regards FSt1 "cjborntorun" wrote: thank you - that does the job "FSt1" wrote: hi =mod(39975,7535) or if 39975 was in a1 and 7535 was in b1 then =mod(a1,b1) Regards FSt1 "cjborntorun" wrote: Please advised on how to calculate: I have a forecast = 39,975 I have a shift qty = 7,535 shift production requirement = 5.3 (39975/7535) What formula will determine the qty of the overage of .3 shifts? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation not correct after decresing decimal point | Excel Discussion (Misc queries) | |||
| Calculation difference after decresing decimal points | Excel Discussion (Misc queries) | |||
| Calculation with Decimal | Excel Worksheet Functions | |||
| problem with decimal in calculation | Excel Discussion (Misc queries) | |||
| Converting decimal calculation to h:mm format | Excel Worksheet Functions | |||
Linear Mode
