Comma Woes
 

assuming you start in row 1 this would work -

=4+(ROW()*2)-2&","&6+(ROW()*2)-2


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391119

Actually that references the row. I kinda need to reference data in a
cell

for example A1 = (4,6) I need B1 to say "6,8" , Or if A1=(x,y) B1 =
(x+2,y+2) Where it references the content instead of the row. But yeah
your formal works perfect for the rows

-Khaos


--
khaos
------------------------------------------------------------------------
khaos's Profile: http://www.excelforum.com/member.php...o&userid=25690
View this thread: http://www.excelforum.com/showthread...hreadid=391119

how about

assuming that cell c1 contains your first input of 4,6

=LEFT(C1,FIND(",",C1)-1)+2&","&MID(C1,FIND(",",C1)+1,LEN(C1))+2


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391119

hmm actually when I open up a new excel sheet and in C1 I put in 4,6 and
past that formula in cell D1 it returns #!VALUE!

Did you ahve the problem?


--
khaos
------------------------------------------------------------------------
khaos's Profile: http://www.excelforum.com/member.php...o&userid=25690
View this thread: http://www.excelforum.com/showthread...hreadid=391119

hehe its pretty frustrating because Ic ant get it right


--
khaos
------------------------------------------------------------------------
khaos's Profile: http://www.excelforum.com/member.php...o&userid=25690
View this thread: http://www.excelforum.com/showthread...hreadid=391119

works fine for me and returns 6,8 providing the 4,6 is a text entry - is
it?


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391119