Formula for greater than or equal to

**jsfisher** · 05-08-2009, 11:04 AM

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

**DonkeyOte** · 05-08-2009, 11:10 AM

a combination of MIN & MAX perhaps ?

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

**jsfisher** · 05-08-2009, 11:39 AM

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

**DonkeyOte** · 05-08-2009, 11:44 AM

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