Ok guys i hope i make it easy...
I want to add number to the cell reference so it changes the cell reference, example:
A1+2 = A3
So that changes the referance number not whats in the cell
Like the value in the cells are:
A1 is 5
A2 is 4
A5 is 3
B1 is IF date is xxxx THEN =a1+0 (so it shows the content of a1) ELSE =a1+a2 (in this case the value of b1 will show the content of a5 because the a2 is=4 so a"1+4" = a5)
I really hope u guys understand it and show me how to do it!!!
Thanks a lot!!!!!!
Thiago
Bookmarks