Feb 25, 2016using "if cell contains #n/a" as a formula condition. Feb 3, 2015this formula will always return the sheet name that the function is positioned from. The -1 parameter ensures that the formula finds the final instance of the ], which will always be the intended.
Nov 25, 2025what formula could i put starting with cell a2 that would create the following computational list of numbers all the way down. So how can i enforce excel to use the value (displayed) of a cell instead of its formula - they mean what you see when the cell is formatted rather than what's actually there.