You could try using this:
=MIN(BE*(MIN(Building%,0.5)-MIN(Building%,0.5)^2),0.25)*BaseEffect
or
=MIN(Building%*BE*MAX(0.5,(1-Building%)),0.25)*BaseEffect
(Both give the same result)
 
			
			You could try using this:
=MIN(BE*(MIN(Building%,0.5)-MIN(Building%,0.5)^2),0.25)*BaseEffect
or
=MIN(Building%*BE*MAX(0.5,(1-Building%)),0.25)*BaseEffect
(Both give the same result)
There are currently 1 users browsing this thread. (0 members and 1 guests)