I assume that you intended either
=IF(A1=5,10,20) + IF(A2=10,40,50)
=SUM(IF(A1=5,10,20) , IF(A2=10,40,50)) ?
--
David Biddulph

Sheeloo wrote:
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?