Jump to content


Please note that this topic has not had any new posts for the last 5469 days.

If you are trying to post a different story then you should start your own new thread. Posting on this thread is likely to mean that you won't get the help and advice that you need.

If you are trying to post information which is relevant to the story in this thread then please flag it up to the site team and they will allow you to post.

Thank you

Recommended Posts

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

Link to post
Share on other sites

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

Link to post
Share on other sites

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

Paul

 

Halifax Status

LBA Sent 11/04/06

1/3 offered by phone 20/04/06 - Rejected

BCT Status

Statements Recieved 31/03/06

Capital One Status

Recieved Lie/Reply 24/04/06

Link to post
Share on other sites

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

Link to post
Share on other sites
  • 12 years later...

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

Link to post
Share on other sites

Please note that this topic has not had any new posts for the last 5469 days.

If you are trying to post a different story then you should start your own new thread. Posting on this thread is likely to mean that you won't get the help and advice that you need.

If you are trying to post information which is relevant to the story in this thread then please flag it up to the site team and they will allow you to post.

Thank you

Guest
This topic is now closed to further replies.
  • Recently Browsing   0 Caggers

    No registered users viewing this page.


  • Have we helped you ...?


×
×
  • Create New...