How would I do a formula for this?

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.
 
K

Ken Johnson

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
 
K

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
 
M

Mike

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.
 
T

Tyro

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
 
Top