Hi
1. What is the role of ADDRESS Function?
2. Could someone translate this formula into English:
=IF(COLUMN(D51)>=$A$48,INDIRECT("Currency!"&ADDRESS(14,$A$48+COLUMNS($B$51:D51)-1-IF($A$48=3,2,IF($A$48=4,4,0)))),0)
This is my attempt.
If 4 >= Value in A48,
then Go to Currency Sheet,
Row 14,
Column 2 + Value in A48 - 1 - IF A48 = 3 then 2, otherwise If A48 = 4, then 4.
Is this correct?
Bookmarks