Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choosing the Larger of Two Numbers
I am trying to write a formula that will allow me to choose the larger of two
values and only include that value (the larger one) in the calculation. For example, B2 is 100 and C2 is 39. I would like the formula to only consider b2 in the overall formula(consisting of other values in the spreadsheet. Is this possible? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choosing the Larger of Two Numbers
Use the MAX function
using your example below you could have a formula somthing like A1*MAX(B2:C2) Regards Paul timfear wrote: I am trying to write a formula that will allow me to choose the larger of two values and only include that value (the larger one) in the calculation. For example, B2 is 100 and C2 is 39. I would like the formula to only consider b2 in the overall formula(consisting of other values in the spreadsheet. Is this possible? Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choosing the Larger of Two Numbers
Excelent! Thank you very much.
"PMC1" wrote: Use the MAX function using your example below you could have a formula somthing like A1*MAX(B2:C2) Regards Paul timfear wrote: I am trying to write a formula that will allow me to choose the larger of two values and only include that value (the larger one) in the calculation. For example, B2 is 100 and C2 is 39. I would like the formula to only consider b2 in the overall formula(consisting of other values in the spreadsheet. Is this possible? Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Choosing the Larger of Two Numbers
=MAX(B2,C2) ?
-- David Biddulph "timfear" wrote in message ... I am trying to write a formula that will allow me to choose the larger of two values and only include that value (the larger one) in the calculation. For example, B2 is 100 and C2 is 39. I would like the formula to only consider b2 in the overall formula(consisting of other values in the spreadsheet. Is this possible? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Pulling larger numbers from group | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) |