In excel can I display a cell based on a calculation (eg M(14/2)?
=INDIRECT("M" & 14/2)
or for more flexibility:
=INDIRECT("M" & A1/A2)
where A1 contains 14 and A2 contains 2
or even:
=INDIRECT(A3 & A1/A2)
where A3 contains "M"
Regards
Trevor
"rnrxtreme" wrote in message
...
|