+ Reply to Thread
Results 1 to 5 of 5

If percent calculation Formula

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    If percent calculation Formula

    Can you help me of the following formulas to my excel sheet?

    Commission Column (Q)


    If O is equal to or greater that H Multiplied by 45 and L is greater or equal to $300 then Q = 10% of K and L + 5% of M and N

    Thanks in Advance

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: If percent calculation Formula

    can you post the formula that you have tried.

    thanks
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: If percent calculation Formula

    Try

    =iF(AND(O2>=H2*45,L2>=300),(K2+L2)*0.1+(M2+N2)*0.05,0)

  4. #4
    Registered User
    Join Date
    02-18-2017
    Location
    Philipin
    MS-Off Ver
    2013
    Posts
    8
    Q2=if(and(o2>=h2*45,l2>=300),(k2+l2)*0.1+(m2+n2)*0.05,0)

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,178

    Re: If percent calculation Formula

    Removed by JT

+ 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. Adding Weighted Calculation to determine percent complete
    By communistflamingo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2015, 09:38 AM
  2. Formula or function to find percent of a percent in a population
    By maldron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2013, 08:26 PM
  3. Calculation weighted average of Percent Change
    By bml63 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-24-2013, 11:34 AM
  4. Calculation of a percent completion based upon due date
    By Anna Mainhart in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-21-2012, 12:16 PM
  5. Percent calculation formula
    By temple1 in forum Excel General
    Replies: 5
    Last Post: 01-10-2012, 02:27 PM
  6. No Calculation Flag, and percent formula
    By cmf0106 in forum Excel General
    Replies: 3
    Last Post: 11-13-2009, 10:41 AM
  7. Calculation using percent
    By rwilson01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2007, 12:52 PM

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