+ Reply to Thread
Results 1 to 2 of 2

Sales Calculations using up to 10 Variables

  1. #1
    Registered User
    Join Date
    07-28-2020
    Location
    Vancouver, BC
    MS-Off Ver
    Office 365
    Posts
    4

    Question Sales Calculations using up to 10 Variables

    Hey there,

    Hoping for some help with this sales projections calculator. I am looking to make calculations in column F based on numerous variables I choose to add or not add to column D.

    For example, if I update cell D8 to $20,000,000.00 and change no other cells in column D, I would like all the formulas in column F to update based on this new variable only. However, if I choose to update cell D8 to $20,000,000.00 AND change cell D11 to 45.0% I would like all the formulas in column F to update once again based on these two variables.

    Is it possible to write a formula with this many variables without having circular references?

    Thank you in advance for any insight provided.

    Cheers,

    Dan
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: Sales Calculations using up to 10 Variables

    Quote Originally Posted by danimill14 View Post
    I would like all the formulas in column F to update once again based on these two variables.
    It may help to know what the expected values are in column F when 20M is placed in cell D8 and 45% is placed in D11.
    When I put those values in the respective cells I see that some cells in column F update and others don't.
    I don't see a circular reference warning, but I also don't know what the values in column F should be.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  2. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  4. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Sales Commission calculations
    By Kevin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Sales Calculations
    By Rainbow4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-14-2005, 07:37 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