LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Worksheets and Cell References - Data Output Natalie Excel Discussion (Misc queries) 1 June 7th 07 08:40 PM
Search range of cells, find a value, output adjoining cell. How? nyys Excel Worksheet Functions 3 January 5th 06 01:48 PM
format cell from data input to output form Brad Stevenson Excel Worksheet Functions 2 May 19th 05 06:04 PM
Comparing data in cells on 2 sheets mayjay Excel Discussion (Misc queries) 1 March 3rd 05 07:58 PM
Using a Text / Data output as a cell reference Jimboski Excel Discussion (Misc queries) 1 February 11th 05 07:31 PM


All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"