So I have a function that returns a number, and I want to use it to represent a Cell.
For example, if I have:
=if(blah,A(5+3),false)
If "blah" is true, then I want the cell to be equal to A8..how can I do this?
Edit: I figured it out..I can either use =index or =indirect
For example, if I have:
=if(blah,A(5+3),false)
If "blah" is true, then I want the cell to be equal to A8..how can I do this?
Edit: I figured it out..I can either use =index or =indirect
Facebook
Twitter