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