Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Dave Symes Newsgroups: comp.sys.acorn.misc Subject: Re: Eureka spreadsheet question. Date: Sat, 18 Aug 2012 19:06:12 +0100 Organization: Triffids Leg Press Lines: 19 Message-ID: <52c14a67f1dave@triffid.co.uk> References: <52bb25d3c0dave@triffid.co.uk> <52bb2c6f3bbrian@bdebenham.co.uk> <52bb5b9fc3dave@triffid.co.uk> <52bf3f2945dave@triffid.co.uk> <26364ebf52.david@david.wisnia.net> <52bf7d76dddave@triffid.co.uk> <9baca5bf52.JohnyBoy@john.bryan86.fsnet.co.uk> <52bfcd4863dave@triffid.co.uk> X-Trace: individual.net Q4yaUw9q86cS69gU8WM5VwX+UgdvgDYuGXCwc7Ku5OdnYc9nvp1krx0VHQbUl44vud X-Orig-Path: triffid.co.uk!dave Cancel-Lock: sha1:cOAAUXuFdnnRui6LCMDmLxhy0eU= User-Agent: Pluto/3.04e (RISC-OS/6.20) NewsHound/v1.52-32 Xref: csiph.com comp.sys.acorn.misc:6154 On 15 Aug, dave@triffid.co.uk wrote: In article <9baca5bf52.JohnyBoy@john.bryan86.fsnet.co.uk>, John Bryan wrote: {Snippy] ` > > You could use a formula in D11 such as: > > =If(Today()-B11>=31,C11*-1,C11) As I mentioned a few days ago, that formula doesn't do anything here. What is it supposed to do? How does it effect the debt turning red? Thanks Dave -- Dave Triffid