I'm sure the question I have is covered in Excel Help but I obviously don't
know how to ask the question so that it displays the answer so I'm hoping
someone here can help. I need to set a formula so that my answer cell looks
at two other cells and displays the greater number. Example - cell 1 says
10.00 and cell 2 says 30.00, I want cell 3 to look at both and put 30.00 in
the cell to show that it is the greater number.
My Question? How would I right the formula? What function would I use for
that?

Thanks for you help
Chat

Use the MAX() for picking the biggest from a reference.

A1 = 10
B1 = 20
C1 = MAX(A1,B1)

If this post helps click Yes
---------------
Jacob Skaria


"chat" wrote:

I'm sure the question I have is covered in Excel Help but I obviously don't
know how to ask the question so that it displays the answer so I'm hoping
someone here can help. I need to set a formula so that my answer cell looks
at two other cells and displays the greater number. Example - cell 1 says
10.00 and cell 2 says 30.00, I want cell 3 to look at both and put 30.00 in
the cell to show that it is the greater number.
My Question? How would I right the formula? What function would I use for
that?

Thanks for you help
Chat

Thank you Jacob!! It works perfectly now.

Chat

"Jacob Skaria" wrote:

Use the MAX() for picking the biggest from a reference.

A1 = 10
B1 = 20
C1 = MAX(A1,B1)

If this post helps click Yes
---------------
Jacob Skaria


"chat" wrote:

I'm sure the question I have is covered in Excel Help but I obviously don't
know how to ask the question so that it displays the answer so I'm hoping
someone here can help. I need to set a formula so that my answer cell looks
at two other cells and displays the greater number. Example - cell 1 says
10.00 and cell 2 says 30.00, I want cell 3 to look at both and put 30.00 in
the cell to show that it is the greater number.
My Question? How would I right the formula? What function would I use for
that?

Thanks for you help
Chat