Groups | Search | Server Info | Login | Register

Groups > comp.sys.acorn.misc > #6107

Eureka spreadsheet question.

Show all headers | View raw

In article <9baca5bf52.JohnyBoy@john.bryan86.fsnet.co.uk>,
   John Bryan <john@bryan86.fsnet.co.uk> wrote:

> > On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
> >> In article <26364ebf52.david@david.wisnia.net>,
> >>    Dave Wisnia at home <david@wisnia.net> wrote:
> >>> In message <52bf3f2945dave@triffid.co.uk>
> >>>           Dave Symes <dave@triffid.co.uk> wrote:

> > [snip]

> >>>> Are there any methods in a sheet whereby when the debt becomes
> >>>> aged of n number of days, the answer in the cell or the
> >>>> cell/colour automatically changes.
> >>
> >>>> For example: When the age become 31 days, then the cell flashes or
> >>>> maybe changes colour to Red.
> >>
> >>> If the number 31 is in cell D5 for example, in the cell next to the
> >>> answer (E5) put =if(D5>31,"OVERDUE!",""). Can't answer re background
> >>> colour change - this will probably need a macro.
> >>
> >> Thanks for the thought... But. I already have an array formula in the
> >> form of...
> >>
> >> {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

[Snippy]

> Eureka's IF function is 
> =IF(logical_test,result_if_true,result_if_false)
> Your line above can be simplified to:
>  =If(D11>=31,"Debtor","Okay") or even simpler IF(D11>=31,"Debtor",0)

> The second one would require the Options-Window-display zero option 
> clear and the Debtor would only appear when over 31 days. You could 
> set the cell font colour to red for more effect.

> When in Okay condition nothing shows but when in Debtor condition the 
> word Debtor would be in red.

> Going on from Tony's reply Eureka allows negative numbers to displayed 
> in {Red} or [Green} or [Blue} etc using the Format-Number option:
>     #,###0.00:{Red}#,###.00    OR  #,###0.00:{Green}#,###.00 etc

Colours need to be specified in Square brackets.
You can also define your own 0.00[Red] for example, but how to get it to
do something useful?
`
> You could use a formula in D11 such as:
> =If(Today()-B11>=31,C11*-1,C11)

Sorry that doesn't do anything here... Possibly because both B11 and Cll
are empty cells.

The only occupied cells in this test sheet are:
All with Invoice date. 1/7/2012
Dll with =Today()-A11+1
E11 with {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

I've noted your shortened form. =If(D11>=31,"Debtor","Okay")

> This would display the cell contents black when less than 31 days
> and red when over 31 days the cell contents have been made negative so 
> that the amount would subtract from any calculation carried out using 
> this cell.

The problem is not getting it to display in [Red] but change from Black to
Red when the debt becomes aged.

> Hope this is of some help

Thanks
Dave

-- 

Dave Triffid

Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-06 20:49 +0100
  Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-06 21:53 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:48 +0100
      Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 09:02 +0100
      Re: Eureka spreadsheet question. M Harding <riscos@mdharding.org.uk> - 2012-08-07 11:22 +0100
        Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 12:33 +0100
        Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 20:04 +0100
  Re: Eureka spreadsheet question. Brian Debenham <brian@bdebenham.co.uk> - 2012-08-06 22:01 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:37 +0100
      Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-14 19:51 +0100
        Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-14 22:35 +0100
          Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 07:11 +0100
            Re: Eureka spreadsheet question. Tony Moore <old_coaster@yahoo.co.uk> - 2012-08-15 10:42 +0000
              Re: Eureka spreadsheet question. Alan Calder <alan_calder@o2.co.uk> - 2012-08-15 13:34 +0100
              Re: Eureka spreadsheet question. John Bryan <john@bryan86.fsnet.co.uk> - 2012-08-15 14:30 +0100
                Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 21:43 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-18 19:06 +0100
                Re: Eureka spreadsheet question. Julian Fry <julainfry@tiscali.co.uk> - 2012-08-19 13:18 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:16 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:18 +0100

csiph-web