Excel Help

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