View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
rnrxtreme rnrxtreme is offline
external usenet poster
 
Posts: 3
Default 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...