| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want the greater number of 2 cells to show in a separate cell
I'm sure this is a simple question, but I can't seem to find the answer...I
want the greater number of 2 cells to show in a separate cell Example... IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the greater number of 2 cells to show in a separate cell
IN cell A3 put this
=MAX(A1:A2) Vaya con Dios, Chuck, CABGx3 "cfiser" wrote in message ... I'm sure this is a simple question, but I can't seem to find the answer...I want the greater number of 2 cells to show in a separate cell Example... IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want the greater number of 2 cells to show in a separate cell
in A3 use the formula
=MAX(A1,A2) "cfiser" wrote: I'm sure this is a simple question, but I can't seem to find the answer...I want the greater number of 2 cells to show in a separate cell Example... IF A1 IS GREATER THAN A2 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 IF A2 IS GREATER THAN A1 THEN I NEED THE GREATER NUMBER TO BE PLACED IN A3 Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Linear Mode
