Formulas to analyze an entry in other columns

[sidegrip]

What I wanting to accomplish is . in column insert #'s SAy In b7 have 7.99 B8..9.1 b9..10.1 and on down .
Then in other columns SAY D column would be formated that if the cell content is of B7 is more than 0 but less than 8 insert cell b7 contents
Then in other columns SAY E column would be formated that if the cell content is of B7 is more than 8.01 but less than 10 insert cell b7 contents
Then in other columns SAY F column would be formated that if the cell content is of B7 is more than 10.0 but less than 13 insert cell b7 content

B7 (Cell D7) if more than 0 = to or less than 8 insert content of B7 (Cell E7) if more than 8.01 and less than or =10 insert content B7
How Can I get this to work???
Thanks
Leonard

[AliGW]

Is this what you are looking for?

e.g. in D7:

=IF(AND(B7>0,B7<8),B7,"")