Results 1 to 2 of 2

Thread: Excel Formula Needed

  1. #1

    Excel Formula Needed



    Register for a FREE account, and/
    or Log in to avoid these ads!

    okay first of all I apologize if this is the wrong forum to ask this question or if it has been answered already. I am trying to create a formula in excel spread sheet to calculate a specific result for example

    Salesman A sold 23 TVs 20 out of 23 TVs were sold with a HDMI cable, which comes out to roughly 87% HDMI attachment rate. How many more TVs with a HDMI cable does he/she need to sell in order to achieve a rating of 90%. answer is "7" he/she needs to sell 7 more TVs with a HDMI cable which would put him/her at 30 total TVs sold and 27 of which include a HDMI cable which is 90% of 30. what formula would I use to have the excel generate this answer for me automatically or am I just expecting too much from MS Excel. I am attaching a sample file with some of the values entered manually just so you guys know what i am trying to accomplish. Thanks in advance.
    Attached Files Attached Files

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    This might be what you want
    Attached Files Attached Files
    Hope that helps

    Roy

Posting Permissions

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