Home 
Search 
Today's Posts 
#1




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




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




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




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) 