Comparing a cell result with a pre-defined value range
 

I have an excel file that calculate a number based on several manual cell
inputs. The resultant, if between a range 300-310 needs to then be passed to
another formaula for calculating the adjustment in a cable length

Hi
do you mean something like
=IF(AND(A1=300,A1<=310),your_formula,"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Antony Weldon" <Antony schrieb im
Newsbeitrag ...
I have an excel file that calculate a number based on several manual
cell
inputs. The resultant, if between a range 300-310 needs to then be
passed to
another formaula for calculating the adjustment in a cable length