Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!att!linac!pacific.mps.ohio-state.edu!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!lll-winken!miguel.llnl.gov!macq
From: macq@miguel.llnl.gov (Don MacQueen)
Newsgroups: comp.sys.mac.apps
Subject: Re: Excel 3 ?'s
Message-ID: <97169@lll-winken.LLNL.GOV>
Date: 13 May 91 17:38:53 GMT
References: <1991May13.000959.11805@athena.mit.edu>
Sender: usenet@lll-winken.LLNL.GOV
Distribution: usa
Organization: Lawrence Livermore National Laboratory
Lines: 15
Nntp-Posting-Host: miguel.llnl.gov

In article <1991May13.000959.11805@athena.mit.edu>, cabruen@athena.mit.edu (Charles Alan Bruen) writes:

|> 
|> 	2. is there a function that simply zeros a value if it is
|> negative. this is what i have been doing but it requires to copies of
|> expression (which are quite long). "if(expr, expr,0)"
|> 

I assume excel has the max and min functions.  If so, try    max(0,expr)

-- 
--------------------
Don MacQueen
macq@miguel.llnl.gov
--------------------