Comparing data in 2 cells to create an output for a 3rd cell

  • Thread starter Thread starter baquirk
  • Start date Start date
B

baquirk

Hi folks. I believe I have a simple question here. I hope someone can
help:

I have two cells of data. For simplicity's sake let's say:

A1 is 5
B1 is 10

I'd like cell C1 to show the higher number in comparing A1 and B1. So
in this case, C1 would show 10.

Might someone help me with the formula?

Thanks much.
 
Hi,

You could just a simple MAX function..

=MAX(A1:B1) this will give you the Maximum number in the range.

Gav.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting cell values based on a 3rd cell 4
Comparing cells and output text 7
Comparing cell contents with different reference cells 3
Compare One Cell to the First 10 Characters of Another Cell 9
if one cell were to equal __ what would the value in another cell 2
Math Functions Not Working Properly 3
Combining several cells into single equasion? 1
formula to make the value in a cell, to a row in a sum function 5

Back
Top