+ Reply to Thread
Results 1 to 5 of 5

I have a sheet that i want to stop calculating a field after it has been calculated

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    19

    I have a sheet that i want to stop calculating a field after it has been calculated

    Hi there, my sheet is Calculating the BE column =IF(Chr.lvl<BF21,"",Skill1*4) if skill1 changes, it calculates previous cells. if your Intelligence modifier goes up it calcs it as it goes. you can't learn something new from the fourth grade when you have already graduated from high school.
    Any other suggestions would be greatly appreciated
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: I have a sheet that i want to stop calculating a field after it has been calculated

    ZOMG third edition. I'll give it a shot.

    What is your desired output? Are you trying to prevent recalculation if skill1 changes?
    Last edited by daffodil11; 09-24-2013 at 02:28 PM.

  3. #3
    Registered User
    Join Date
    04-16-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    19

    Re: I have a sheet that i want to stop calculating a field after it has been calculated

    yes. you get ability points every 4 levels if you put them into INT then it goes up every 8 levels

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: I have a sheet that i want to stop calculating a field after it has been calculated

    ::cough cough:: You could always use the 3.5 Variant Rule where it applies retroactively ::cough min/maxing cough::

    Otherwise, this is tough. I'm thinking a circular reference, possibly in conjunction with a hidden timestamp. I'll research it further.

  5. #5
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: I have a sheet that i want to stop calculating a field after it has been calculated

    Okay, I rolled a 1 on my Excel (Int) check after a few hundred tries.

    Turn on circular references under Options -> Formulas -> Enable Iterations


    For BE21:
    =IF(BE21<>"",IF(CHR.lvl>=BF21,Skill1*4,""),"")

    For BE22 and onwards:
    =IF(BE22<>"",IF(CHR.lvl>=BF22,Skill1,""),"")

    With the circular reference and iterative calculations turned on, the formula will check if the cell itself is blank, and if it isn't it will update. This will prevent values from changing once they already have skill points assigned for those levels.

    I'm giving myself 500 xp.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  2. Replies: 2
    Last Post: 03-06-2009, 11:49 AM
  3. [SOLVED] PivotTable:Using a calculated field result in another calculated f
    By Alice in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-08-2006, 12:25 PM
  4. Replies: 3
    Last Post: 06-06-2006, 12:10 AM
  5. Replies: 0
    Last Post: 01-09-2006, 11:45 AM

Tags for this Thread

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