Comparing a cell result with a pre-defined value range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select a range not equal to: 4
How do I have a cell value define a dynamic named range? 15
Holding the result of a formula constant or frozen 1
fit multiple values into specific value (combinations?) 4
SUMIF on a Calculated Field 3
how do i get excel to use data in a table based on the result of a 2
varying a cell and seeing the outcome 2
a data validation list that contains a list of named ranges - not alist from a named range 1

Back
Top