Hi,
I have come across the following formula. Could any one explain me where are such formulas used?
=INDEX(INDIRECT(AG3),Age-16,Term-IF(S15="IRR",8,3))
Thanks
Hi,
I have come across the following formula. Could any one explain me where are such formulas used?
=INDEX(INDIRECT(AG3),Age-16,Term-IF(S15="IRR",8,3))
Thanks
INDIRECT formula will work, if AG contain any reference of other cell..
In your case AG3 should be filled with something like.. "A5:I17"
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks