Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a cell with data seperately
Hi,
Thanks for getting back to me, i didn't make this clear enough for instance the data in col A could vary as below I want to be able to divide the second number i.e 14/7.5 and so on without typing in a different formula in each case. A1 B1 7.5-14 8.5-15 9.5-7 7-18 Thanks Haz "Gary''s Student" wrote: enter: =11/7.5 -- Gary''s Student - gsnu200776 "Haz" wrote: Hi, I am having problems with summing data in a cell. For instance in cell A1 I have 7.5 - 11 and in B2 I want to write a function that will divide 11/7.5 to give me 1.46 is there a function that can do this for me rather than type in 7.5 and 11 in two seperate cell? Any help here would be much appreciated Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a cell with data seperately
Hi Haz
try =MID(A1,FIND("-",A1)+1,255)/LEFT(A1,FIND("-",A1)-1) Copy down as far as required -- Regards Roger Govier "Haz" wrote in message ... Hi, Thanks for getting back to me, i didn't make this clear enough for instance the data in col A could vary as below I want to be able to divide the second number i.e 14/7.5 and so on without typing in a different formula in each case. A1 B1 7.5-14 8.5-15 9.5-7 7-18 Thanks Haz "Gary''s Student" wrote: enter: =11/7.5 -- Gary''s Student - gsnu200776 "Haz" wrote: Hi, I am having problems with summing data in a cell. For instance in cell A1 I have 7.5 - 11 and in B2 I want to write a function that will divide 11/7.5 to give me 1.46 is there a function that can do this for me rather than type in 7.5 and 11 in two seperate cell? Any help here would be much appreciated Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a cell with data seperately
Thanks, this worked perfectly "Roger Govier" wrote: Hi Haz try =MID(A1,FIND("-",A1)+1,255)/LEFT(A1,FIND("-",A1)-1) Copy down as far as required -- Regards Roger Govier "Haz" wrote in message ... Hi, Thanks for getting back to me, i didn't make this clear enough for instance the data in col A could vary as below I want to be able to divide the second number i.e 14/7.5 and so on without typing in a different formula in each case. A1 B1 7.5-14 8.5-15 9.5-7 7-18 Thanks Haz "Gary''s Student" wrote: enter: =11/7.5 -- Gary''s Student - gsnu200776 "Haz" wrote: Hi, I am having problems with summing data in a cell. For instance in cell A1 I have 7.5 - 11 and in B2 I want to write a function that will divide 11/7.5 to give me 1.46 is there a function that can do this for me rather than type in 7.5 and 11 in two seperate cell? Any help here would be much appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
How to save a worksheet seperately in addition to part of wrkbook | Excel Discussion (Misc queries) | |||
How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) | |||
Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
How do I Group Buttons to operate seperately from eachother? | Excel Discussion (Misc queries) |