returning a value based on mulitple criteria
I would like to have a formula that would return a value based on the
following criteria
A11000 or B14% return a value of 25
A11500 or B15% return a value of 50
A12000 or B16% return a value of 75
Here's the tricky part. I always want it to return the higher value. In
other words if the value in A1 is 1100 but the value in B1 is 5.5% then I
want it to return a value of 50.
|