• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel: Using a returned value to represent a Cell?

S

Syringer

Lifer
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
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top