Hi.



I am in need of a formula that converts a value in a specific cell to a value that lies within a range of cells automatically.

For example, if (P5) is "3.3" (the average of P2-P4), then (P6) should be (C25) (sorry you can't see this...screenshot cut off after C20)

The added complexity is that I will be regularly modifying the values in P2-P4, so the formula in P6 needs to update automatically.

So, if I change values in P2-P4, and say P5 now reads "4.8", then P6 would need to automatically be "96" in (C11).

See picture, below.

THANKS.


Screen Shot 2016-11-06 at 8.46.59 PM.png