Results 1 to 3 of 3

Skip calculation based on other cell value in a macro

Threaded View

avarax Skip calculation based on... 08-23-2013, 09:24 PM
avarax Re: Skip calculation based on... 08-24-2013, 08:14 AM
avarax Re: Skip calculation based on... 09-02-2013, 01:18 PM
  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    at home
    MS-Off Ver
    Excel 2010
    Posts
    9

    Skip calculation based on other cell value in a macro

    Kindly see attached spreadsheet calculator.

    My intention with the "Margin Dialpad" buttons to the left is to simply clear out the cell values that are displayed in row 46, and subsequently calculate with a Goal Seek function the margin as you can see it when pressing a button on the "Margin Dialpad".

    Two questions/issues:
    1) In case you selected "Operating / True Lease" in cell E24, you have to also select a balloon payment in the highlighted cell in red in line 38. In the attached example I had selectd 9%.
    Once you made a percentage selection, I like the "Margin Dialpad" buttons to skip all calculation, except for the selected term length. In the attached example it is 60 months. Of course I like that skipping logic to change if a different term length was selected and different cells in row 46 are empty.
    In summary: I like this calculation only to execute when there is a value to be found in cells in row 38.

    2) When hitting the "Margin Dialpad" buttons: Instead of the calculation running through from left to right, column by column, I was hoping there is a way to combine the routine into one step and have them all calculate at the same time. Just like it deletes all values when you first hit the button. Any ideas?

    Thanks a lot in advance!
    Cheers,
    Axel
    Attached Files Attached Files
    Last edited by avarax; 08-24-2013 at 08:12 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help in an iterative macro to copy/skip row based on cell value
    By rhiminee in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-13-2012, 03:08 PM
  2. Replies: 0
    Last Post: 10-13-2011, 01:11 PM
  3. need to skip calculation
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2007, 01:44 PM
  4. skip cell if blank go on to use another cell in calculation
    By sosborne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-08-2006, 05:35 PM
  5. Hide/unhide sheet macro based on cell calculation
    By Greg Fisher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2005, 05:19 PM

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