View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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