ExcelRaceRatings
New Member
- Joined
- Jan 9, 2016
- Messages
- 25
- Office Version
- 2016
- Platform
- Windows
Hello,
Hoping someone can assist with an IF Formula issue i am having as per the below photo.
What i would like to achieve is to adjust the current formula in Column BV (Revised Fig) so that the calculation is only performed on figures in column AO (RTG) based on the criteria in Column BX (Race ID). The way it is currently set up is that it is performing the calculation on all figures in Column AO (RTG) and thats not what i am after.
So basically in BV2:BV8 it should be revising the figures of AO2:AO8 from 14 through to 1 because BX2:BX8 is RACE ID *1.
Any assistance would be greatly appreciated?
Hoping someone can assist with an IF Formula issue i am having as per the below photo.
What i would like to achieve is to adjust the current formula in Column BV (Revised Fig) so that the calculation is only performed on figures in column AO (RTG) based on the criteria in Column BX (Race ID). The way it is currently set up is that it is performing the calculation on all figures in Column AO (RTG) and thats not what i am after.
So basically in BV2:BV8 it should be revising the figures of AO2:AO8 from 14 through to 1 because BX2:BX8 is RACE ID *1.
Any assistance would be greatly appreciated?