Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Greater of Two Cells

Simple when you know how!!!!!

Many thanks, PCLIVE

"PCLIVE" wrote:

=MAX(A1:A2)

"Simon y Glog" <Simon y wrote in message
...
Guys -

I want a function to return the greater value of two cells. How do I do it
please?

For example, cell A1 contains the number 1.
Cell A2 contains the number 2.
Cell A3 contains the function which will return "2"

Thanks in advance for your efforts




Reply
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
need to add a group of cells if greater than 30 and less than 60 Alex Excel Discussion (Misc queries) 2 June 24th 06 06:27 PM
Count non-contiguous cells where value is greater than 0 anre5180 Excel Worksheet Functions 2 February 22nd 06 01:12 PM
I want the greater number of 2 cells to show in a separate cel cfiser Excel Discussion (Misc queries) 0 November 16th 05 10:03 PM
Average If Adejecent Cells Greater Than Zero REW2705 Excel Worksheet Functions 3 October 21st 05 12:41 AM
How go I get cells to change color if a date is greater than 365 . Brett Setting up and Configuration of Excel 1 February 12th 05 03:07 AM


All times are GMT +1. The time now is 09:44 PM.

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"