dave

[Tarby25]

having real problems with your excel spreadsheet mate

i can change the reason and amount with no problem but when i change the date incurred the 8% apr comes up with #VALUE!

what am i doing wrong and can you help me correct it

regards

Tarby

[mas101]

Hi

 

The most likely cause of the problem is that you may have inadvertently changed the formula so that it has become corrupt. The easiest way to do it is to simply open a new version of the spreadsheet in the library and copy and paste the relevant column back into your own spreadsheet. It will then just auto-calculate everything you need.

 

Hope this helps

[Tarby25]

hello there thats what i thought but it doesnt matter how many new spreadsheets i bring up the same thing happens

[ispartacus75]

have you tried putting the date in in different formats?

 

dd/mm/yy

dd/mm/yyyy

mm/dd/yy

mm/dd/yyyy

 

If it cant understant your date structure it will throw back an error.

 

Might be worth a try

[Tarby25]

thankyou paul you are a certified genius

i think that it should be put next to the spreadsheet that the date must be inputed american style month / day/ year

but thank you again paul

[ispartacus75]

Glad to have been of service

[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