| 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 |
| 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) | |||
Threaded Mode
