IF Formula Assistance

[ExcelRaceRatings]

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?

 

[NiMip]

This is pretty similar to a problem you posted yesterday with the same title...

IF Formula Assistance

Hi All, Figuring this most likely a very simple fix but i'm having issues getting it right. Basically the formula in the description is found in Column F and relates to figures found in Column E. What i would like to do is incorporate into the formula that it revises figures based on the date...

www.mrexcel.com

Did you have any luck with that one? The solution should be pretty much the same

 

[Peter_SSs]

@ExcelRaceRatings
I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ExcelRaceRatings]

I tried it out but couldn't seem to get a positive.

This is a slightly different spreadsheet but the same principles apply within the formula. This is what happens when i tried your solution. Unless i have misunderstood?

 

[Peter_SSs]

Thanks for updating your profile.
Now can you provide that sample data with XL2BB to make it easier for helpers by not having to manually type out sample data to test with?

It might also help if you could explain in words what the formula is supposed to do.

What would be the correct expected results (calculated manually) for say cells BV2:BV4 if we can implement the change you want?

 

[NiMip]

I tried it out but couldn't seem to get a positive.

This is a slightly different spreadsheet but the same principles apply within the formula. This is what happens when i tried your solution. Unless i have misunderstood?

View attachment 21926

I think you're missing a couple of closed parentheses; check that you've introduced a new one to close out each of the new IF statements properly.

In your original formula you have: CEILING((AO2-MIN(...))/...
In the new one you have: CEILING((AO2-MIN(IF(...))/...

There are still only two closed parentheses at the end of the second one, despite you introducing the IF function.

 

[ExcelRaceRatings]

Sorry for the late reply @NiMip but yes this suggestion got everything working perfectly. Well done!

 

[NiMip]

Sorry for the late reply @NiMip but yes this suggestion got everything working perfectly. Well done!

Oh excellent glad to have helped!

 

[ExcelRaceRatings]

The above worked really well but adding the array has slowed my spreadsheet to an absolute walk and barely useable.

Any ideas about how to get around this without the array @NiMip ?

 

[NiMip]

The above worked really well but adding the array has slowed my spreadsheet to an absolute walk and barely useable.

Any ideas about how to get around this without the array @NiMip ?

Oh yeah arrays can be a bit heavy if you have lots of data :/ I have one other idea... I'll have a play and get back to you