+ Reply to Thread
Results 1 to 2 of 2

Inconsistent Formula??

  1. #1
    Registered User
    Join Date
    03-10-2006
    Posts
    77

    Inconsistent Formula??

    I'm using this formula: =IF(PlayersList!$C$4=0,"",PlayersList!$C$4) to pull names from a "PlayersList" sheet and place them in several places in the workbook. I'm using this formula TWICE per sheet per "player" In other words I've got a column with the players name as the heading, then 20 rows beneath it, the same players name for a TOTAL POINTS row. The formula works in every place, but on the lower part (total points row) I get a green triangle in the corner of the cells. Is this an inconsistent formula and if so, why doesn't it show that way on the original cell?? and how can I correct it???

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,237
    you must have a circular reference, which really means that the formula is in the same range as the formula, if you know what I mean

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1