+ Reply to Thread
Results 1 to 4 of 4

excel 2013 if formula to use pick which higher List price to pick in Comm calculation

  1. #1
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    excel 2013 if formula to use pick which higher List price to pick in Comm calculation

    have 2 List price , wants to calculate commission from which is higher list price,
    how can I write the if formula , having hard time adding the formula

    for example

    B3 ----150,000.00 List price
    B5 ------160,0000.00 List price
    D6 --------- Commission column - to pick the list price which the higher , if both column same than pick the B3

    can someone please help with if formula

    really appreciate all the help

    see attached the file
    thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

    Hi,

    Try this:
    =IF(B3=B5,B3,MAX(B3,B5))

    Regards,


    Edit:
    Actually you dont need IF as if both prices are same, both cell contain the same value, so you can go with just:
    =MAX(B3,B5)
    Last edited by Khalidngo; 12-08-2016 at 09:18 AM.
    Khalid

  3. #3
    Forum Contributor
    Join Date
    01-31-2013
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

    thanks for replying Khalidngo

    but D6 amount changed a lot if I changed the make amount 0 on A5 margin adj cell


    have updated the file

    A5 have Margin adj amount if I make that Margin adj 0

    List Price -----357871.00 B3 cell
    List Price --------357871.00 B5 cell

    List Price ------- 357871.00 C6 cell

    Standard D6 $ 228,000.00
    Nonstandard E6 $ 139871.00

    D6 should be total of B3 or B5 -E6 =D6

    if the add amount on A5 or not

    can you please help.

    D6 amount should be if margin adj 0 Standard D6 amount should be $218000.0
    if margin adj amount 10000.00 than D6 Standard amount should be $ 228000.00

    really appreciate all the help

    thanks again
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-17-2014
    Location
    Uppsala, Sweden
    MS-Off Ver
    2010
    Posts
    43

    Re: excel 2013 if formula to use pick which higher List price to pick in Comm calculation

    Hi,

    If A6=0, then B3 will be same as B5 and you will just return that value in D6, and not 218000.


    Are you sure you don't just want, in D6, B5-E6? Since B5 already is connected to B3 and A6.

+ 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. Excel 2013 confused re active cell, worksheet etc after CommandBars...ShowPopups user pick
    By Nelson Johnson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-23-2016, 08:33 AM
  2. Replies: 3
    Last Post: 06-19-2015, 01:58 PM
  3. Pick diff pick list as per column value
    By ROHAN999 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-10-2013, 12:10 PM
  4. Replies: 7
    Last Post: 09-12-2013, 03:54 PM
  5. Replies: 3
    Last Post: 11-12-2012, 08:59 AM
  6. Excel 2007 : Pick-List pick fills in another cell
    By hpasso217 in forum Excel General
    Replies: 0
    Last Post: 02-28-2011, 05:38 PM
  7. [SOLVED] Making pick list conditional on selection from previous pick list
    By Stewart in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 07:05 AM

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