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:E8CCDA8FF60E4D48BDE88B35760E2BD3(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 