Can anyone help me with adding to an address reference? I am trying to add a cell to an address reference. For example, the using the address function a cell returns the text $AH$11. I would like to subtract 3 to that reference so it becomes $AH$8. Ultimately, I will use a minimum function with these two cells as the range. Is this possible? Can anyone help?