Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-1395552%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1395552%22%20slang%3D%22en-US%22%3E%3CP%3EI%20m%20a%20new%20to%20excel%20and%20I%20would%20like%20to%20know%20if%20there%20is%20a%26nbsp%3Bway%20to%20do%20the%20following%3C%2FP%3E%3CP%3EIn%20cell%20M5%20-%20Regardless%20of%20what%20one%20is%20selected%20from%20B5%20to%20K5%20%2C%20the%20value%20would%20display%20here%20*100%25%3C%2FP%3E%3CP%3EIn%20N5-%20Regardless%20of%20what%202%20are%20chosen%2C%20they%20would%20be%20added%20together%20and%20multiplied%20by%2090%25%3C%2FP%3E%3CP%3EIn%20O5%20%2C%20Regardless%20of%20any%203%20chosen%20%2C%20they%20would%20be%20added%20together%20and%20multiplied%20by%2095%25%3C%2FP%3E%3CP%3ESo%20if%20I%20wanted%20any%207%20communities%20added%20together%20and%20multiplied%20by%20a%20%25age%20it%26nbsp%3Bwould%20calculate%20in%20the%20cell%20automatically.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1395552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

I m a new to excel and I would like to know if there is a way to do the following

In cell M5 - Regardless of what one is selected from B5 to K5 , the value would display here *100%

In N5- Regardless of what 2 are chosen, they would be added together and multiplied by 90%

In O5 , Regardless of any 3 chosen , they would be added together and multiplied by 95%

So if I wanted any 7 communities added together and multiplied by a %age it would calculate in the cell automatically.

0 Replies