Add 100 only if greater than a value (condition)

[rolysudest]

Can somebody help me?:
I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1))
But, only if AB946 is greater or equal to 5200, I wish the result to be increased with 100 (+100).

Thank U very much!

 

[Joe4]

I am not sure if I understand what you want to do, but maybe this:

[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]MAX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ROUNDUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]AB946[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]/[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]25[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]) + IF(AB946>=5200,100,0)[/FONT][/COLOR]

If that does not give you what you want, please explain exactly what you want to happen in detail.

 

[rolysudest]

I am not sure if I understand what you want to do, but maybe this:

[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]MAX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ROUNDUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]AB946[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]/[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]25[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]) + IF(AB946>=5200,100,0)[/FONT][/COLOR]

If that does not give you what you want, please explain exactly what you want to happen in detail.

Thank U, Joe4, it worked!

 

[rolysudest]

I am not sure if I understand what you want to do, but maybe this:

[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]MAX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ROUNDUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]AB946[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]/[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]25[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]) + IF(AB946>=5200,100,0)[/FONT][/COLOR]

If that does not give you what you want, please explain exactly what you want to happen in detail.

Thank U, Joe4!
And, if AB946 is greater or equal to 5200, I wish also to "replace" AB946 with AB946-200, so that IF AB946 >= 5200, to make the calculation =MAX(100,ROUNDUP((AB946-200)/25,-1))) Is that possible? Is that somehow a conflict?
Thanks!

 

[Joe4]

Try this:

=IF(AB946>=5200,MAX(100,ROUNDUP((AB946-200)/25,-1))+100,[COLOR=#000000][FONT=Inconsolata]MAX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ROUNDUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]AB946[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]/[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]25[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]))[/FONT][/COLOR]

 

[rolysudest]

Try this:

=IF(AB946>=5200,MAX(100,ROUNDUP((AB946-200)/25,-1))+100,[COLOR=#000000][FONT=Inconsolata]MAX[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ROUNDUP[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]AB946[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]/[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]25[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata],[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]1[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]))[/FONT][/COLOR]

It worked! Thank U, Joe4!

 

[Joe4]

You are welcome.