Can someone tell me how to compare two cells (numbers), and then display the larger cell?
Cell C1 = IF A1 > B1 then display A1 else display B1
Sorry I'm not an excel pro.
comparisonconditional statementsmicrosoft excel
Can someone tell me how to compare two cells (numbers), and then display the larger cell?
Cell C1 = IF A1 > B1 then display A1 else display B1
Sorry I'm not an excel pro.
Best Answer
A bit late but if someone else is having trouble: The MAX(number1;number2;...) function is what you're looking for. "Returns the largest value in a set of values. Ignores logical values and text."