| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing data in 2 cells to create an output for a 3rd cell
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing data in 2 cells to create an output for a 3rd cell
Hi,
You could just a simple MAX function.. =MAX(A1:B1) this will give you the Maximum number in the range. Gav. " wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing data in 2 cells to create an output for a 3rd cell
Simple is all I need. That's perfect. Thanks very much.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Worksheets and Cell References - Data Output | Excel Discussion (Misc queries) | |||
| Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
| format cell from data input to output form | Excel Worksheet Functions | |||
| Comparing data in cells on 2 sheets | Excel Discussion (Misc queries) | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
Linear Mode
