Excel Sorting Problem

[Pete Kuncis]

I have a spreadsheet. I am trying to sort by a certain column. The formula
in that column is:

=IF(U16>(W16*AB$14),"U",IF(W16>(U16*AB$14),"O","N/A"))
=IF(U17>(W17*AB$14),"U",IF(W17>(U17*AB$14),"O","N/A"))
=IF(U18>(W18*AB$14),"U",IF(W18>(U18*AB$14),"O","N/A"))
etc (~60 more rows)

When I sort column AB, it does not properly sort. It tries, but stuff is
out of order. Should be O's, U's, and N/A's

Crazy thing is, if I sort column U, then column W, then column AB, it sorts
correctly?!? Any ideas where to possibly begin with this? Columns U and W
are formulas also (cell value divided by a fixed number).

It seems like a hiccup, but I'd like to get it figured out so it doesn't
hiccup anymore.

Thanks,
Peter

 

[Pete Kuncis]

I found the problem. Found the user had mistyped formulas in the W column.
Sorting by that column must have fixed the problem, then sorting by AB worked
fine.

Pete