Comma Woes

K

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!
 
K

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
 
R

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
 
K

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
 
Top