How would I do a formula for this?

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

How do I set up a formula that will do >than one number but <than another
number will equal something. Like >4.5 but <7 in one cell will = 10 in this
cell.
 
How do I set up a formula that will do >than one number but <than another
number will equal something. Like >4.5 but <7 in one cell will = 10 in this
cell.
Click to expand...

Possibly...

=IF(AND(A1>4.5,A1<7),10,"")

which tests if A1 is between 4.5 and 7 (Not including 4.5 or 7) then
makes the cell with the formula 10 when the test is true and blank,"",
when false.

Ken Johnson
 
Possibly...

=IF(AND(A1>4.5,A1<7),10,"")

which tests if A1 is between 4.5 and 7 (Not including 4.5 or 7) then
makes the cell with the formula 10 when the test is true and blank,"",
when false.

Ken Johnson
Click to expand...

You can even get away without using any worksheet functions...

=(A1>4.5)*(A1<7)*10

which returns 10 when test is true and 0 when false

Ken Johnson
 
Wow thanks guy! I like how this site is set up for idiots like me to come
and ask one simple question and get positive responses to help me out, except
from you. So was that a question or a comment from you? Isn't worded like a
question, but for some reason has a question mark at the end. To Ken
Johnson, thank you for your help!!! Tyro, as soon as you write and publish a
book I'll be the first to buy it.
 
If you never educate yourself, you will keep asking the simple question you
asked. If you want to be continually dependent on others, do so. I always
buy books, read, try to find the answer for myself and when I cannot, I ask
others. I have been teaching for over 40 years. What I find most is that
people will not read the manual. They find reading to be too hard. So they
ask others rather than even trying to read. I feel sorry for them. A very
good book for you to buy has been written by John Walkenbach. I do not know
what version of Excel you have since you didn't consider it important to
enlighten us. If you had I could have given you the ISBN of his book. The
books he writes are about $40 (U.S.). Happy reading!

Tyro
 

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

Excel Need Countifs Formula Help 0
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
need formula help 6
Create an Averaging Formula 1
Excel multiple conditional formulas 3
Help with this formula 3
Finding Text within an Array 2
Windows 10 How do I stop Windows automatically adding a space after punctuation 3

Back
Top