Check number within a range
 

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?

Check number within a range
 

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(a1A2,A1<=A3),True_formula_goes_here,False _result_goes_here)

"djungst" wrote:

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?

Check number within a range
 

=IF(AND(xy,x<=z),your_calculation,"")

will return a blank if the criteria is not true

--


Regards,


Peo Sjoblom

"djungst" wrote in message
...
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?