If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#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, 
Ads 
#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, 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
conditional formatting  Lofty  Excel Worksheet Functions  7  July 10th 06 09:06 PM 
How to generate sets of random numbers without having duplicates  William  Excel Worksheet Functions  1  June 6th 06 05:30 AM 
Why are 1/2 my numbers imported as text and the rest as numbers?  KBear  Excel Discussion (Misc queries)  2  April 21st 06 01:40 PM 
Pulling larger numbers from group  Smint  Excel Worksheet Functions  3  June 14th 05 08:55 PM 
Checking Winning Numbers in the Lottery.  Ann  Excel Discussion (Misc queries)  4  May 18th 05 10:55 AM 