Forum Discussion
JoshyBoshy
Sep 26, 2022Copper Contributor
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
mtarler
Sep 26, 2022Silver Contributor
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?
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?