Forum Discussion
Solved
Cell location while filtering
Hi Folks, This is probably a simple procedure, but I haven't been able to figure it out. I have a cell with a few nested if/or statements that rely on the data in another cell. For example, let's...
You may use directly like
=IF(<formula>="Something","Name1","no name")
but better to keep formula result in helper cell(s) and use them for the reference.
SergeiBaklan Wow, thank you! I have absolutely no idea what is happening in your code, but it does what I need it to. I'll have to figure out how to integrate that into the If/or statement, but it shouldn't be too tough.
You may use directly like
=IF(<formula>="Something","Name1","no name")
but better to keep formula result in helper cell(s) and use them for the reference.