Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Eureka spreadsheet question.

Show all headers | View raw

In message <fa4196bf52.old_coaster@old_coaster.yahoo.co.uk>
          Tony Moore <old_coaster@yahoo.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"))}

> I know nothing about Eureka, but PipeDream allows a negative velue to be
> displayed in red. This could be applied to a cell showing '30 - age'.

> Tony

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

You could use a formula in D11 such as:
=If(Today()-B11>=31,C11*-1,C11)

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.

Hope this is of some help

-- 
John Bryan

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