interest

[Tarby25]

hello

just wondered if someone can help

ive created a spraedsheet with al my relevant information regarding bank charges dates and days since occurance as per the guide in the library

just stuck on the next step of how to work out th interest on the charges is the spreadsheet supposed to do it for you or is there a magic button that i have to press

not overly computer savvy

all advice gratefully recieved

p.s. im sure someone has alraedy posted and been answered to about this subject but for love nor money can i find it

thankyou.................

[Tarby25]

ok so now ive realised that is was the spreadsheet that was already set up that i was suppossed to be using not my own DOH :?

but now im using the actual template one its fine when i change the charge amount but when i change the date it the 8% total field says

hash VALUE!

 

HELP

[gomadnomad]

Only change the reason for charge and date incurred field not the interest column or the days since offence column and ensure are using the correct date format i.e 13/03/2006 and it should work. Try this then come back here.

[Tarby25]

still comes up with hash value! whenever i change the date incurred

[laura1clark]

try widening the column, the figure might be too high to fit in

[Tarby25]

sorted now thanks

had to put the date in american style

month/day/year

[Tarby25]

This topic was closed on 03/06/19.

If you have a problem which is similar to the issues raised in this topic, then please start a new thread and you will get help and support there.

If you would like to post up some information which is relevant to this particular topic then please flag the issue up to the site team and the thread will be reopened.

- Consumer Action Group