Exceluser0105
New Member
- Joined
- Jun 30, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am having trouble getting the below equation to work (Please note this equation is contained within an if statement):
GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0)
The Geomean formula normally requires an array with a ={geomean(array+1)-1} format. Without the array the geomean calculated is different.
How can I create the array formula in the above equation? Am I able to within the full equation as shown below?
=IF(S9="","",GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0),'Variable 1'!S9,1)))
GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0)
The Geomean formula normally requires an array with a ={geomean(array+1)-1} format. Without the array the geomean calculated is different.
How can I create the array formula in the above equation? Am I able to within the full equation as shown below?
=IF(S9="","",GEOMEAN(OFFSET(Rates!$C$2,MATCH('Variable 1'!P9,Rates!$B$3:$B$300,0),MATCH('Variable 1'!N9,Rates!$D$2:$DB$2,0),'Variable 1'!S9,1)))