| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare two values
Hi, I need to compare two values (in adjacent cells), and select the higher
of the two to perform an additional function on ? Many Thanks Graham |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare two values
use IF function
Eg: Cell A1: 25, Cell B1: 30 Cell C1: =IF(A1B1,A1+10,B1+10) Please do rate Thanks in advance "Graham" wrote: Hi, I need to compare two values (in adjacent cells), and select the higher of the two to perform an additional function on ? Many Thanks Graham |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare two values
=MAX(A1,B1)
to use in your other cell .... =MAX(A1,B1)*C1 "Muhammed Rafeek M" wrote: use IF function Eg: Cell A1: 25, Cell B1: 30 Cell C1: =IF(A1B1,A1+10,B1+10) Please do rate Thanks in advance "Graham" wrote: Hi, I need to compare two values (in adjacent cells), and select the higher of the two to perform an additional function on ? Many Thanks Graham |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare two values
Mon, 23 Jul 2007 02:56:01 -0700 from Graham
: Hi, I need to compare two values (in adjacent cells), and select the higher of the two to perform an additional function on ? =MAX(A1,A2)+55 -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Compare two values
Many Thanks, a little more involveed than I first thought, but at least I now
know where to start from. "Muhammed Rafeek M" wrote: use IF function Eg: Cell A1: 25, Cell B1: 30 Cell C1: =IF(A1B1,A1+10,B1+10) Please do rate Thanks in advance "Graham" wrote: Hi, I need to compare two values (in adjacent cells), and select the higher of the two to perform an additional function on ? Many Thanks Graham |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Values | Excel Worksheet Functions | |||
| Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
| compare values | Excel Worksheet Functions | |||
| compare a few values | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Linear Mode
