Prev: COUNTIF
Next: What does " mean in excel
From: hollisterbulldawg on 5 Mar 2010 20:39
I need to calculate my loss on a rental property but the loss cannot be
greater than $25,000 no matter how large it actually is. How do I write an
Excel formula that will include this maximum value limit?
From: Fred Smith on 5 Mar 2010 20:44
Use the Min function, as in:
=min(25000,yourformula)

Regards,
Fred

"hollisterbulldawg" <hollisterbulldawg(a)discussions.microsoft.com> wrote in
message news:E8CCDA8F-F60E-4D48-BDE8-8B35760E2BD3(a)microsoft.com...
>I need to calculate my loss on a rental property but the loss cannot be
> greater than $25,000 no matter how large it actually is. How do I write an
> Excel formula that will include this maximum value limit?

 | 
Pages: 1
Prev: COUNTIF
Next: What does " mean in excel