If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
record dozens and singles in same cell and sum them?
I would like to record dozens and single units in single cells with a view to
using them in calculations. E.G. stock sheet - 12,4 in one cell added to 10,2 in another cell resulting with an answer 0f 22,6 in a third cell with the 22 representing 22 dozen items and the 6 representing 6 single items. |
#2
|
|||
|
|||
record dozens and singles in same cell and sum them?
Hi,
With your 2 numbers in a1.B1 try this =(LEFT(A1,FIND(",",A1)-1))+LEFT(B1,FIND(",",B1)-1)&","&MID(A1,FIND(",",A1)+1,LEN(A1))+MID(B1,FIND( ",",B1)+1,LEN(B1)) Mike "Calculating Dozens" wrote: I would like to record dozens and single units in single cells with a view to using them in calculations. E.G. stock sheet - 12,4 in one cell added to 10,2 in another cell resulting with an answer 0f 22,6 in a third cell with the 22 representing 22 dozen items and the 6 representing 6 single items. |
#3
|
|||
|
|||
record dozens and singles in same cell and sum them?
"Calculating Dozens" wrote: I would like to record dozens and single units in single cells with a view to using them in calculations. E.G. stock sheet - 12,4 in one cell added to 10,2 in another cell resulting with an answer 0f 22,6 in a third cell with the 22 representing 22 dozen items and the 6 representing 6 single items. You could also use the trick of separating the two numbers with a decimal point. Use a very large number of places to avoid overflow. So for example the numbers could be 12.000004 and 10.000002 adding them gives 22.000006 The numbers can also be separated very easily using the =int function |
Thread Tools | |
Display Modes | |
|
|