I went with the index one as simpler.
But I do appreciate your suggestion which will come in handy sometime soon
for me.
Best,
Sat

"Dan E" wrote in message
...
My apologies, i didn't notice that hiccup when B15 = 12
If I read that right
B15 < 12 is A15 - A25
B15 = 12 is A23
B15 12 is A26 up

=IF(B15<12,INDIRECT("A"&14+B15),IF(B1512,INDIRECT ("A"&13+B15),A23))

Dan E

"Dan E" wrote in message
...
I think this will work for you

=INDIRECT("A" & 14 + B15)

Dan E

"saturnin02" wrote in message
...
Hi,
I need to calculate If staments based on the formula below.
Unfortunately, there are too many nested IF statements.

How can I write this formula in a more intellignet way that will work?





=IF(B15=1,A15,IF(B15=2,A16,IF(B15=3,A17,IF(B15=4,A 18,IF(B15=5,A19,IF(B15=6,A



20,IF(B15=7,A21,if(B15=8,A22,IF(B15=9,A23,IF(B15=1 0,A24,IF(b15=11,A25,IF(B15
=12,A23,IF(B15=13,A26,IF(B15=14,A27)))))))

Tx,

Sat