View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Haz Haz is offline
external usenet poster
 
Posts: 46
Default 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