Hi, new to the forum.
Trying to get my head around spreadsheets, and I've hit a brick wall.
I want a formula which expresses a value as 0,1,3 should the data be less than -0.30, between -.3 and +.3 or greater than +0.30.
So, for example...
If cell E2 is -0.1, I want cell I2 to display 1...because the value is between -.30 and +.30.
If cell E2 is -0.5, I want cell I2 to display 0... because the value is less than -.30.
If cell E2 is 1.1, I want cell I2 to display 3...because the value is greater than +.30.
I'm assuming it's an IF formula, but I keep coming up with errors in the formula.
Any help would be appreciated.
Regards
Bookmarks