On Jan 9, 1:00 pm, Ken Johnson wrote:
On Jan 9, 12:49 pm, Mike wrote:

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.

Possibly...

=IF(AND(A14.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

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

=(A14.5)*(A1<7)*10

which returns 10 when test is true and 0 when false

Ken Johnson