Check if a number is within a certain range

A

ainese

Hi

I'm trying to check if a number is within a certain range.

EG:
say i get a result of 9% in a cell, and in the next cell i want to
check if that falls between the range of 0.1% and 10% and if it does
then apply a formula how do i do this?

Anyone know please?
 
C

Craig Schiller

Where Don has 1, substitute what you want to happen if the conditions
are true. Where Don has 2, substitute what you want to happen if the
conditions are false.
 
D

Don Guillett

Where is the formula that gives a result of 9%. Is is rounding? Post your
data
 
Top