Numerical excel regional judge

In the first table in front of value to use for the multiplier, and then on to judge the multiplier can not be greater than a certain value can not be less than a certain value.
Me cite an example, A1 = 6, A2 = 7, in the A1 and A3 called the product of A2, A3 in the number of requests can not be greater than 45 can not be less than 40.If more than 45 to 45 showed that if less than 40 to 40 showed that, in this range of Shows that the actual value.Is there such a function? I remember is there, but could not find the.
Added:first in a cell evaluation, and then the target cell can also get to judge , I would like to know is on the target cell type formula can be carried out to determine the function of the job.Thank you! !

= if (a1 * a2> 45,45, if (a1 * a2 45,45, IF (A1 * B1 <40,40, A1 * B1)) = min (max (a1 * a2, 40), 45)

Leave a Reply