Check number within a range

[djungst]

I would like to check a number to see if it is greater than one number and
less than or equal to another number and if it is perform a calculation on
the number. How do I write that formula?

 

[Duke Carey]

let's say the number to test is in A1, the lower bound is in A2, and the
upper bound is in A3

=if(and(a1>A2,A1<=A3),True_formula_goes_here,False_result_goes_here)

 

[Peo Sjoblom]

=IF(AND(x>y,x<=z),your_calculation,"")

will return a blank if the criteria is not true

--


Regards,


Peo Sjoblom