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, |
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, |
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, |
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, |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com