In excel can I display a cell based on a calculation (eg M(14/2)?
 

In excel can I display a cell based on a calculation (eg M(14/2)?
 

Not sure what exactly you are trying to do, but you can do:

Dim r as long

r = 14\2
Cells(r, 3).Select


RBS


"rnrxtreme" wrote in message
...

In excel can I display a cell based on a calculation (eg M(14/2)?
 

Display where?

msgbox activesheet.cells(cint(14/2),13).value

--
Tim Williams
Palo Alto, CA


"rnrxtreme" wrote in message ...

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
...

In excel can I display a cell based on a calculation (eg M(14/
 

Thank you very much.

In excel can I display a cell based on a calculation (eg M(14/
 

Does this not work when there's a text command in the equation

I'm inputting =INDIRECT("B" & ROUNDDOWN($AA$1/$A11^D$37,0))

(all listed cells exist)

and it shows an error...

In excel can I display a cell based on a calculation (eg M(14/
 

You need to check what ROUNDDOWN($AA$1/$A11^D$37,0) evaluates to. It
needs to be a number between 1 and 65536. If it is likely not to be a
number you'll need to put some error checking in it and decide what you want
the value to be if there is an error.

Regards

Trevor


"rnrxtreme" wrote in message
...
Does this not work when there's a text command in the equation

I'm inputting =INDIRECT("B" & ROUNDDOWN($AA$1/$A11^D$37,0))

(all listed cells exist)

and it shows an error...