Comma Woes

[khaos]

Hi im just trying to figureout how to make a function that can do this.

Current cell info says "4,6" I need the cell next to it to go to "6,8"
so increments of 2 for a whole column. But I dont know what function to
stick in there so it'll do this command.

anyhelp will be greatly appreciated!

 

[Ruthki]

assuming you start in row 1 this would work -

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

 

[khaos]

Actually that references the row. I kinda need to reference data in
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 yea
your formal works perfect for the rows

-Khao

 

[Ruthki]

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

 

[khaos]

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

Did you ahve the problem

 

[khaos]

hehe its pretty frustrating because Ic ant get it righ

 

[Ruthki]

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