Forum Discussion
i Need Help with rearranging Numbers
I NEED SOMEONE TO HELP ME REARRANGE FOUR NUMBERSWITH A FORMULA IN A DECENDING ORDER ONLY USING IF AND OR
3 Replies
- let me guess, class homework?
It isn't possible using ONLY if and or you have to use comparators too. Also can you use AND? are you saying only using: IF, AND, OR
or are you saying using only: IF & OR
also are you looking for 4 formulas (i.e. 1 for each cell) or does this have to be 1 formula that will spill the 4 results? Which version of Excel are you using?
I see you've tagged 365. If that's the case, like Harun24HR said, SORT is your best option.
- Why not SORT() function?
