Formula using "lesser of"

[SHamilton58]

I need to build a formula that will calculate the lesser of a specific cell
total, or a constant #.

Example. If the calculation/formula of cell C13 = $500,000.... I need
cell C14 to automatically display C13's answer, or $685,000, whichever is
less. The answer in this example would obviously be $500,000, but can I
build a formula to calculate this?

Thank you!

 

[Niek Otten]

=MIN(C13,500000)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I need to build a formula that will calculate the lesser of a specific cell
| total, or a constant #.
|
| Example. If the calculation/formula of cell C13 = $500,000.... I need
| cell C14 to automatically display C13's answer, or $685,000, whichever is
| less. The answer in this example would obviously be $500,000, but can I
| build a formula to calculate this?
|
| Thank you!
|
|
| --
| SHamilton58

 

[Rick Rothstein \(MVP - VB\)]

You grabbed the wrong number Niek...

=MIN(C13,685000)

Rick

 

[Niek Otten]

Thanks, Rick!

I shouldn't even have tried to answer that question; I can't be trusted with even the simplest math!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| You grabbed the wrong number Niek...
|
| =MIN(C13,685000)
|
| Rick
|
|
| | > =MIN(C13,500000)
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |I need to build a formula that will calculate the lesser of a specific
| > cell
| > | total, or a constant #.
| > |
| > | Example. If the calculation/formula of cell C13 = $500,000.... I
| > need
| > | cell C14 to automatically display C13's answer, or $685,000, whichever
| > is
| > | less. The answer in this example would obviously be $500,000, but can I
| > | build a formula to calculate this?
| > |
| > | Thank you!
| > |
| > |
| > | --
| > | SHamilton58
| >
| >
|