how to set max increase limit in excel

[Habib_Taan]

Let's say I'm disturbing tips between my staff, but I want to set the max amount an individual employee can get (let's say 30,000)

Furthmore, I want to pay certain department * 1.5 or even 2. Is it possible? 

[#2]

@Habib_Taan 

Like this?

=ROUND(MIN($B3,$A3/SUM($C$2:$H$2)*C$2),2)

[#3]

епвнрвпсс

[#4]

билощлш слоши двадрщлд