View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
[email protected] meh2030@gmail.com is offline
external usenet poster
 
Posts: 135
Default Choosing a cell with the greater number

On Dec 15, 3:21 pm, Maddie wrote:
Column A has a list of numbers and Column B has a list of numbers. In column
C, I would like it to select the greater number from cell A or B. Can
somebody tell me how to formulate that? Thank you.


Try using the MAX function. For example, if you have a number in cell
A1 and another number in cell B1, place the following formula in cell
C1: =MAX(A1,B1). I think that this is what you are asking.