Re: [ARMini-support] Schema spreadsheet
- From: Jim Lesurf <jcgl@xxxxxxxxxxxxxxx>
- To: armini-support@xxxxxxxxxxxxx
- Date: Sun, 19 Oct 2014 10:04:24 +0100
In article <9e0bba5854.Iyonix@xxxxxxxxxxxxxxxxxxxx>, Barry J
<barryjerome@xxxxxxxxxxxxxx> wrote:
> In message <3297a95854.rcomp@xxxxxxxxxxxxxxxxxxx> A Rawnsley
> <rcomp@xxxxxxxxxxx> wrote:
> A few of the formulae in my spreadsheet which I did not find how to
> convert are::
> =FLOOR((SUM(F49:F64)/H15)) =CEIL((SUM(G49:G64)/H15)) =if C$22<=0 then 0
> else if C$22<F26 then C$22 else F26 endif endif =if C22-(F27+F22)<=0
> then 0 else F27+F22 endif =if (C22-C27-C26-(B7+B8+B9))<=0 then 0 else
> C22-C27-C26-(B7+B8+B9) endif
> =L_REPLACE("2008-2009",0,9((LEFT($A$2,4)-2) cat"-" cat
> (RIGHT($A$2,4)-2)))
I've not checked, but wonder if PipeDream might do the job.
Jim
--
Electronics http://www.st-and.ac.uk/~www_pa/Scots_Guide/intro/electron.htm
Audio Misc http://www.audiomisc.co.uk/index.html
Armstrong Audio http://www.audiomisc.co.uk/Armstrong/armstrong.html
---
To alter your preferences or leave the group,
visit //www.freelists.org/list/armini-support
List-related queries to info@xxxxxxxxxxxx
Other related posts:
