Results 1 to 3 of 3

Thread: help - beginner

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2012

    help - beginner

    Hi I've been rattling by brains trying to work out how either write an excel formula or to find VB code for the following (It may be very easy and I am probably missing something very basic so apologies in advance.) -

    in excel I have box K9 which holds a sales target percentage. in box K26 I would like to show how much commission I currently have based on my current % towards my target. This needs to change each time the % changes.

    for 100% I would earn 500.

    I have a complete mind block and can only think of creating an extremely long IF formula in Excel so wondered if a VB code would be easier?

    Any help would be most appreciated.

  2. #2
    Super Moderator FunkyDexter's Avatar
    Join Date
    Apr 2005
    An obscure body in the SK system. The inhabitants call it Earth

    Re: help - beginner

    Stepping away from excel, if you called your target X, your current Y and your commission Z, could you express Z as an algabraic formula in terms of X & Y on a piece of paper? If so then it should be just as easy to write the formula into excel. If not (because it's a stepped function, for example) then, one way or another you'll have to look up against some sort of enumeration.

    There are ways of handling enumerations in excel (you basically put them in an area of the spreadsheet and then you can reference them from elsewhere) and in VB. The excel way is a little trickier than VB but, since it's going to save you the hassle of installing VB add-ons, macros etc, I think I'd still stick with excel if it was me.
    You can depend upon the Americans to do the right thing. But only after they have exhausted every other possibility - Winston Churchill

    Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd

  3. #3
    Join Date
    Mar 2009

    Re: help - beginner

    in cell k26 type : =k9*5

Posting Permissions

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


Click Here to Expand Forum to Full Width