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. 

-- 
--
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

Attachment: signature.asc
Description: PGP signature

Reply via email to