I have a spreadsheet where I am comparing 2 cells with each other, then whichever is larger, I need the spreadsheet to enter the larger value.If a2>c2, then enter value in a2, but if c2>a2, then enter value in c2. How do I do this? It's been many years since I have had to use Excel formulas.

To compare two cells in a spreadsheet and return the larger value, you can use the MAX function. e.g MAX(A2, C2)

Forum Discussion

Copper Contributor

Feb 27, 2025

I have a spreadsheet where I am comparing 2 cells with each other, then whichever is larger, I need the spreadsheet to enter the larger value.

If a2>c2, then enter value in a2, but if c2>a2, then enter value in c2.

How do I do this? It's been many years since I have had to use Excel formulas.

AbhijeetJadhav
Copper Contributor
Feb 27, 2025
To compare two cells in a spreadsheet and return the larger value, you can use the MAX function. e.g MAX(A2, C2)