Closed Thread
Results 1 to 4 of 4

If formula for compensation worksheet

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    8

    If formula for compensation worksheet

    How do you write a formula for:

    If column A = "Associate" then column F * $53.00?, but if column B="Partner", then column H * Column C17.

    I got the first part up to the $53.00 and 0 if false, but wasn't able to continue with the remainder of the formula. Is that possible to place it all in one formula?

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: If formula for compensation worksheet

    Use:

    =IF(A17="Associate", F17 * 53, If(B17="Partner", H17 * C17, ""))
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: If formula for compensation worksheet

    Please take a few minutes to read the forum rules, and then start a new thread in one of the question forums. This isn't one.

    Thanks.
    Last edited by Paul; 02-13-2012 at 01:43 AM. Reason: Moved thread out of non-question forum.
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    04-04-2011
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: If formula for compensation worksheet

    The first IF A17="Associate" worked, but the B17 "Partner" did not work as written.

Closed Thread

Thread Information

Users Browsing this Thread

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

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