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? Jim Allan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
