Excel Logic test returning incorrect responses

I have 3 columns of raw data. The are order: 5th, 50th and 95th percentiles. I am trying to do a logic check for order, but I'm getting false results

I have tried both of these statements:

=IF(F2>E2>D2,1,0)

=IF(F2>E2,1,0)


In both cases I get 1 no matter whether the statement is true.

I've also noticed that I can get 0 when the data is 30, 20, 0 when I enter the formula on that line but not when I copy and paste from an above line.

When I copy and paste from the line that has 30, 20, 0, I get 0 for all other lines even though the order of the values is increasing.

So it seems to be giving me the value for line from which I'm copying.

I've checked and the copy and paste formula IS changing the row value correctly to correspond to the new row.

I'm befuddled and really need to get this data check done.

Thanks,

Here's what I'm actually seeing (except that the columns line up):

5th percentile 50th percentile 95th percentile 95>50>5
*20 *25 32* =IF(F2>E2,1,0)
*25 *30 32* =IF(F3>E3,1,0)
*25 *30 45* =IF(F4>E4,1,0)
*4 *5 6* =IF(F5>E5,1,0)
*2 3 *4 =IF(F6>E6,1,0)
3 1 0 =IF(F7>E7,1,0)

One weird thing I'm noticing is that the numbers in the last 2 columns won't allign to the center when I choose allign center. They are all formatted "number"