Hello. I'm trying to work on a formula that essentially rounds down if the value is between two numbers, or shows the correct value if it is not. I'm trying to do this with an "=IF" function, though let me know if there's an easier way.

I have two columns: in one (E2) is the value 8, in the other (F2) is currently the value 8.8. E2-F2 is -0.8, which for my purposes in this spreadsheet has the value of 0. If the values in E2 and F2 were different, and the subtraction of the two was outside of the range of -0.8:0.i would want to see the true value of E2-F2.

I'm currently trying to build the formulae as follows: =IF(SUM(E2-F2)=-0.8:0,0,SUM(E2-F2)

Translated to: If the sum of E2-F2 is within range of -0.8 to 0, please display as 0. If not, please display as the sum of E2-F2.

Sorry for the rambling nature, this is my first post in this sub.