Home

trying to Caculate overall score for each employee using a 100-point scale

%3CLINGO-SUB%20id%3D%22lingo-sub-909434%22%20slang%3D%22en-US%22%3Etrying%20to%20Caculate%20overall%20score%20for%20each%20employee%20using%20a%20100-point%20scale%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-909434%22%20slang%3D%22en-US%22%3E%3CP%3E30%25%20is%20one%20column%2070%25%20is%20other%20column%20how%20do%20I%20formulate%20this%20thankyou!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-909434%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ebrasni145
Occasional Visitor

30% is one column 70% is other column how do I formulate this thankyou!

1 Reply

@ebrasni145 

If your range starts in Row 2, this formula in C2 returns the weighted score: 

=SUMPRODUCT(A2:B2,
{0.3,0.7})

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies