Thread: If Then
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default If Then

Enter this in C1: =IF(A1B1,A1,B1)


--
Brevity is the soul of wit.


"face" wrote:

I would like to do the following:

Determine which cell is greater, A1 or B1. Display whichever is greater in C1.

Thanks!