| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Then
I would like to do the following:
Determine which cell is greater, A1 or B1. Display whichever is greater in C1. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then
Enter this in C1: =IF(A1B1,A1,B1)
-- Brevity is the soul of wit. "face" wrote: I would like to do the following: Determine which cell is greater, A1 or B1. Display whichever is greater in C1. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then
In C1 enter:
=MAX(A1,B1) -- Gary''s Student gsnu200701 "face" wrote: I would like to do the following: Determine which cell is greater, A1 or B1. Display whichever is greater in C1. Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then
I figured it out.
= IF(A1 B1,A1,B1) "face" wrote: I would like to do the following: Determine which cell is greater, A1 or B1. Display whichever is greater in C1. Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Then
Great but please do not overwork IF.
Gary's use of MAX is the best method for your problem best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "face" wrote in message ... I figured it out. = IF(A1 B1,A1,B1) "face" wrote: I would like to do the following: Determine which cell is greater, A1 or B1. Display whichever is greater in C1. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
