Multiple conditions

[rolysudest]

I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1)) + IF(AB946>=5200,100,0) - thanks to Joe4
But, only if AB946 is greater or equal to 5200, I wish also to add a condition to the above formula: to "replace" AB946 with AB946-200, so that IF AB946 >= 5200, to make the calculation =MAX(100,ROUNDUP((AB946-200)/25,-1)))+ IF(AB946>=5200-200,100,0), keeping the conditions in the bolded formula above. Is that possible? Is that somehow a conflict?
Thanks!

 

[Joe4]

Solved here: https://www.mrexcel.com/forum/excel...100-only-if-greater-than-value-condition.html

Please be careful not to post the same question in multiple threads. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).