Creating a function that cannot be greater than .2

waffle

Registered User.
Local time
Yesterday, 20:55
Joined
Nov 3, 2006
Messages
13
I have a function that I would like to max out at .2 and I don't know how to go about doing that.
Currently it is
Equip Inf: (([Equipment]*(0.03*(2006-[Letting Date]))+[Equipment])/([Equipment]))-1
and then I multiply (1+[Equip Inf])*[Equipment] to get my inflation. What I want is for Equip Inf to never be greater than .2 or 20%
What is the best way to do this?
 
Code:
Equip Inf: IIF((([Equipment]*(0.03*(2006-[Letting Date]))+[Equipment])/([Equipment]))-1)>.2,.2,((([Equipment]*(0.03*(2006-[Letting Date]))+[Equipment])/([Equipment]))-1))
 
Thanks worked Great!
 

Users who are viewing this thread

Back
Top Bottom