Reference formula
 

hello,

I´m tring to organize a table with various source and basicly what i can´t
find a way to do is this:

exemple:
A2= 10
A3= morning

A4= A2+1
what i want is that the result be "morning" and not 11 (10+1), excel add 1
to the reference in A2 and i want it to move 1(for exemplo) cells

can you help?

Reference formula
 

You want to use Offset
=offset(a2,1,0,1,1)

return the cell offset by 1 row and 0 columns with a size of height of 1 and
a width of 1
"formula help" wrote:

hello,

I´m tring to organize a table with various source and basicly what i can´t
find a way to do is this:

exemple:
A2= 10
A3= morning

A4= A2+1
what i want is that the result be "morning" and not 11 (10+1), excel add 1
to the reference in A2 and i want it to move 1(for exemplo) cells

can you help?

Reference formula
 

Your formula is simply adding 1 to A2 so the result isn't surprising, if you
want to have morning in A4 then simply put =A3 in cell A4

"formula help" wrote:

hello,

I´m tring to organize a table with various source and basicly what i can´t
find a way to do is this:

exemple:
A2= 10
A3= morning

A4= A2+1
what i want is that the result be "morning" and not 11 (10+1), excel add 1
to the reference in A2 and i want it to move 1(for exemplo) cells

can you help?

Reference formula
 

like i said:
i want to add to the formula not to the result, FOR EXAMPLE: A2+1= A3 (2+1=3)

it´s an example to show what i´m tring to do, and not my objective

"Mike" wrote:

Your formula is simply adding 1 to A2 so the result isn't surprising, if you
want to have morning in A4 then simply put =A3 in cell A4

"formula help" wrote:

hello,

I´m tring to organize a table with various source and basicly what i can´t
find a way to do is this:

exemple:
A2= 10
A3= morning

A4= A2+1
what i want is that the result be "morning" and not 11 (10+1), excel add 1
to the reference in A2 and i want it to move 1(for exemplo) cells

can you help?