| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Largest of Two Values
I want a formula that returns the largest of two values located in different
cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
=IF(B1A1,B1,C1)
Mike "JerryS" wrote: I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
Try this:
=MAX(B1,C1) Returns whichever is the larger of the two. Hope this helps. Pete "JerryS" wrote in message ... I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
=LARGE(A1:A19,{1})
Change the range to suit your needs... Regards, Ryan-- -- RyGuy "Pete_UK" wrote: Try this: =MAX(B1,C1) Returns whichever is the larger of the two. Hope this helps. Pete "JerryS" wrote in message ... I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
You added an extra reference (and had them set up for the minimum I think).
I believe you wanted to post this formula instead... =IF(C1A1,C1,A1) Rick "Mike H" wrote in message ... =IF(B1A1,B1,C1) Mike "JerryS" wrote: I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
Okay, the only excuse for posting this formula is that it is late on a
Friday afternoon.<g =(A1+C1+ABS(A1-C1))/2 Rick "JerryS" wrote in message ... I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Largest of Two Values
You might want to read a book on basic Excel. You'll definitely find your
answer there. Tyro "JerryS" wrote in message ... I want a formula that returns the largest of two values located in different cells. For example, A1 = $15.00, B1 = formula 1, C1 = A1+5%. For D1, I want it to return either B1 or C1 with the criteria being if B1 is greater than A1, then the answer is B1. If not, then the answer is C1. Any suggestions? Thanks -- JerryS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel summing N largest values by condition | Excel Discussion (Misc queries) | |||
| Add largest Values | Excel Discussion (Misc queries) | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Select Largest 5 in A, AVG values in B | Excel Worksheet Functions | |||
| How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
Linear Mode
