Tom Ogilvy wrote:
Another approach: (demo'd in the immediate window)

i = 10
? "=RC[-1]/" & "RC[" & i & "]"
=RC[-1]/RC[10]

Hi Tom
I think this is a different result formt what the OP wants to achieve.
Your formula would result in a value (the division result). But if I
understood the OP correctly he wants a text consisting of both values
operands and the '/' as text delimiter. So he would see something like
"3/4" in his target cell

Frank