I want to use an IF statement or other function that would allow me to place
a value in a cell other than the cell that formula is evaluated in based on
some logical tests. For example: I have a number I want to transpose x
cells from where my formula is evaluated based on some criteria that would be
evaluated based on some data cells. Is there a way to do that?