ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Logic Formulas (https://www.excelbanter.com/excel-worksheet-functions/124701-logic-formulas.html)

BWatson10

Logic Formulas
 
I don't know how to create a logic formula by selecting two cells and
creating that formula to select the greater of the two in another cell

Don Guillett

Logic Formulas
 
=max(a2,a4)

--
Don Guillett
SalesAid Software

"BWatson10" wrote in message
...
I don't know how to create a logic formula by selecting two cells and
creating that formula to select the greater of the two in another cell




Ron Coderre

Logic Formulas
 
Try something like this:

With
A1 and B1 containing values

then
C1: =MAX(A1:B1)

or if the cells are separated.....this formula returns the maximum of cells
A1 and D10
=MAX(A1,D10)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"BWatson10" wrote:

I don't know how to create a logic formula by selecting two cells and
creating that formula to select the greater of the two in another cell


Lori

Logic Formulas
 
=MAX(A1,B1)

entered in a cell selects the returns the greater of the two cells

BWatson10 wrote:
I don't know how to create a logic formula by selecting two cells and
creating that formula to select the greater of the two in another cell




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com