Reference formula

F

formula help

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?
 
J

Joel

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
 
M

Mike

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
 
F

formula help

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
 
Top