+ Reply to Thread
Results 1 to 2 of 2

To calculate the value for two different variables changes

  1. #1
    Registered User
    Join Date
    09-02-2013
    Location
    chennai, india
    MS-Off Ver
    Excel 2003
    Posts
    1

    To calculate the value for two different variables changes

    Dear masters,
    i want to know how to calculate

    if a1=some value say x
    and b1= some other value say y
    then c1= some value say z.

    The value of x and y are variable numbers.

    For ex.
    If someones pay is x and he joined in the month y then his increment will be z

    x can be 20000 or 30000 or 40000 or 50000
    y may be 1 or 2 or 3 or 4

    z may be some value we have to give. .
    How to get the formula for this . Please help me.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: To calculate the value for two different variables changes

    Welcome to the Forum balalikowshik!

    Let's forget about Excel for just one minute. If you know x and y, how do you figure out what z is? If you can explain that, then it will be quite easy to tell you how to do it in Excel. In your example, you tell us that x can be pay and y can be 1-4 but you do not explain what an increment is (pay raise?) or how to figure it out based on x and y.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Calculate cost with three variables
    By Keltic in forum Excel General
    Replies: 3
    Last Post: 04-22-2012, 11:17 AM
  2. Calculate for three variables
    By SRodin in forum Excel General
    Replies: 2
    Last Post: 01-09-2012, 12:24 PM
  3. Calculate Pro-Rata Share of Two Variables
    By wealthistime in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-21-2010, 04:36 PM
  4. Calculate Yes / No Variables?
    By mycon73 in forum Excel General
    Replies: 4
    Last Post: 03-26-2010, 03:22 AM
  5. [SOLVED] calculate all possible combination from 10 variables
    By silvia in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-12-2006, 08:10 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