# 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

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

a combination of MIN & MAX perhaps ?

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

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

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)))

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1