On Mon, 09 Jun 2008 14:54:15 -0400 Jim Allan <[EMAIL PROTECTED]> wrote:
> Jerry Feldman wrote: > > I need a function to find the lowest of a fixed value and a cell. > > SMALL(range;n) is not what I need. > > > > something like =if(150 <= $a$1;150;$a$1) > > > > I could use this, but I'm looking for something cleaner. > > What about =MIN(72;A1) in which 72 is your fixed value and A1 is the cell? On Mon, 09 Jun 2008 14:57:07 -0400 Joe Smith <[EMAIL PROTECTED]> wrote: > =MIN(150;$A$1) As an experienced C/C++ software engineer I am really embarrassed on this one. I can't tell you how many times I've used min and max in FORTRAN/C/C++. Thanks Joe and Jim for the quick response. -- -- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
