# Formula for greater than or equal to

1. ## Formula for greater than or equal to

How do I write a formula whereas the end result is capped at a certain percentage.

For example:

=d13*(1+b14), the solution to that part of the formula cannot be greater than d4. I am very new at this, I know how to do the math but not create the formula

15000 * 1 plus the percentage = x but cannot be greater than y and if is a negative number cannot be less than 0

Any help would be greatly appreciated  Register To Reply

2. ## Re: Formula for greater than or equal to

a combination of MIN & MAX perhaps ?

=MAX(0,MIN(D4,D13*(1+B14)))  Register To Reply

3. ## Re: Formula for greater than or equal to

d13*(1+b14)
40000*1.1953=47812
Anytime b14 is greater than d4 it should multiply by d4 which in this case is 7%. Also if b14 is a negative # the anser always has to equal zero.

When I inputed your formula my output was .07 but it should be 42800
40000*1.07

Any ideas on what I am doing wrong  Register To Reply

4. ## Re: Formula for greater than or equal to

Maybe it's be but it's not very clear what you want to do re: -ve %... whether entire result should be 0 or the multiplication should simply be 1 ?

Perhaps you want:

=D13*(1+(MAX(0,MIN(B14,D4)))  Register To Reply

5. ## Re: Formula for greater than or equal to

Thank you very much, your second formula did the trick. I would have never figured this out on my own. I appreciate you taking the time to help me  Register To Reply