Can I display a cell based on a calculation (eg M(14/2)?

  • Thread starter Thread starter Guest
  • Start date Start date
Maybe.




On Thu, 29 Jun 2006 14:03:02 -0700, rnrxtreme


Gord Dibben MS Excel MVP
 
I don't know what you want to do. If you want a cell to display the result
of a calculation like 14/7, type "=14/7" without the quotes, in a cell and
hit Enter. HTH Otto
 
If C1 contained
=14/2
Then you could display:
A7 with
=INDEX(A:A,C1)
OR
G1 (7th column) with
=INDEX(1:1,C1)

You could also use Indirect:
A7
=INDIRECT("A"&C1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Scrabble Value calculation for Welsh words 0
Changing Sum Range Based on Date Chosen from Drop Down List 1
Trying to lookup values on another sheet 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculating Average Length of Service 2
Calculate elapsed time excluding specific timeframe 10
New 2007 Sumifs formula - Is there a new 2 criteria vlookup? 2

Back
Top