View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default 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
...