Thread: INDEX error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_4_] Sheeloo[_4_] is offline
external usenet poster
 
Posts: 225
Default INDEX error

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?