Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 2 of 2

Thread: Error #NAME?

Hybrid View

  1. #1
    New Member
    Join Date
    Feb 2015
    Posts
    1

    Error #NAME?

    Hello,

    First, thank you for the wonderful spreadsheet. It's a tremendous help.

    However, I am having a few issues getting it to work. I believe that I have correctly entered the required data in the settings, deposits, and bets sheets, but in the bets sheet, in the table for At Risk-Payout-Profit/Loss all it is displaying is #NAME? for all entries. The same error occurs on the Available Funds sheet (although, it does correctly calculate Net Deposits, Bonus Credit, and Net Winnings). What could be the cause of this?

    Please let me know if you require any more information to help, and I thank you in advance.

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi musicmantribalx,

    The #NAME error occurs if a formula is trying to reference a name that it can't find. Looking at the first "At Risk" cell the formula is:
    =ROUND(IF(M9<>"Y";IF(P9<>"Y";K9;K9*(BB9-1));0);ROUNDING)

    It seems like the spreadsheet can't find the ROUNDING variable, which should be located in a hidden cell R4 in the Settings worksheet. Have you made any changes to this sheet? If you unlock the Bets worksheet (using the password sport) and change the formula for cell R9 to:
    =ROUND(IF(M9<>"Y";IF(P9<>"Y";K9;K9*(BB9-1));0);2)
    does this fix the problem? If so, then it is the ROUNDING variable that the spreadsheet can't find. What you could do then is enter the value 2 into a cell somewhere in the sheet then select Insert -> Names -> Define. Call the cell ROUNDING and see if that fixes the issue.

    If you're still experiencing issues, send me a PM and I'll give you an email address to send your spreadsheet to.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •