Article View: comp.sys.mac.apps
Article #9056Re: Excel 3 ?'s
From: Don MacQueen
Date: Mon, 13 May 1991 17:38
Date: Mon, 13 May 1991 17:38
15 lines
1035 bytes
1035 bytes
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 --------------------
Technical Details
Message-ID:
<97169@lll-winken.LLNL.GOV>Path:
arc1-ca.pugleaf.net!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!macqReferences:
<1991May13.000959.11805@athena.mit.edu>Show Full Headers
Complete Article Headers
Path: arc1-ca.pugleaf.net!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