Thread: Substitute formula

If cell A1 contains numeric DATA .
Result Cell B1 should display:

IF Cell A1 (DATA) -0.1 to -1.0; Cell B1 (Display substitute) A
IF Cell A1 (DATA) -1.1 to -1.4 Cell B1 (Display substitute) B
IF Cell A1 (DATA) -1.5 to -2.0; Cell B1 (Display substitute) C
IF Cell A1 (DATA) -2.1 to -2.4; Cell B1 (Display substitute) D
IF Cell A1 (DATA) -2.4 or less; Cell B1 (Display substitute) E

IF Cell A1 (DATA) 0.1 to 1.0; Cell B1 (Display substitute) F
Cell A1 (DATA) 1.1 to 1.4 Cell B1 (Display substitute) G
IF Cell A1 (DATA) 1.5 to 2.0; Cell B1 (Display substitute) H
IF Cell A1 (DATA) 2.1 to 2.4; Cell B1 (Display substitute) I
IF Cell A1 (DATA) 2.4 or more; Cell B1 (Display substitute) J
How can I write a formula?
Thanks.