Remember Me?

#1
January 15th 07, 04:51 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 3
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
January 15th 07, 05:03 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 23
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
January 15th 07, 05:17 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jan 2007 Posts: 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
January 15th 07, 05:31 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Dec 2006 Posts: 620
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,

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Lofty Excel Worksheet Functions 7 July 10th 06 09:06 PM William Excel Worksheet Functions 1 June 6th 06 05:30 AM KBear Excel Discussion (Misc queries) 2 April 21st 06 01:40 PM Smint Excel Worksheet Functions 3 June 14th 05 08:55 PM Ann Excel Discussion (Misc queries) 4 May 18th 05 10:55 AM

All times are GMT +1. The time now is 06:46 AM.