+ Reply to Thread
Results 1 to 2 of 2

Need to add a logical calculation

  1. #1
    Registered User
    Join Date
    Munich, Germany
    MS-Off Ver

    Need to add a logical calculation

    Hi together,
    I hope you can see this picture and my excel file. It's an example for my problem.

    In reality i got a lot of more data so i cant handle this manually.

    The most important thing ist to look for the same MP NR. In this example there are just two possibilities, 1 and 2. For all rows with the same MP I need to calculate the same calculation to get an weighted rating. You can see the needed calculation in the picture.

    I spend a lot tiime with solving this problem and also spoke to my collagues but all of them didnt know how to manage it.
    Im really unsure if its possible at all.

    It would be great if you can help me. Even if you say its not possible you could help me.

    Thank you!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by humalfa; 04-23-2020 at 05:49 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)

    Re: Need to add a logical calculation

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.

    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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. Need help with logical calculation
    By notsosmartypants in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2015, 06:02 AM
  2. Time Calculation using Logical function
    By L Raju in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-16-2014, 04:00 AM
  3. logical and time calculation problem
    By wba in forum Excel General
    Replies: 4
    Last Post: 07-01-2012, 07:05 AM
  4. Logical calculation of fees and currencies
    By bakuvi in forum Excel General
    Replies: 4
    Last Post: 11-17-2009, 05:06 PM
  5. Using Logical Function in Pivot Calculation
    By Mike G in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2006, 12:10 PM
  6. numeric calculation in logical formula
    By Chris Vermaak in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-25-2005, 07:05 AM
  7. pivot table logical calculation
    By Spencer Hutton in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-08-2005, 03:06 PM

Tags for this Thread


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