View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Choosing a cell with the greater number

=MAX(A1,B1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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.