Thread: [Solved] If (cell) is (range of cells), then (cell) should be (range of cells)
View Single Post
 
Old 11-06-2016, 08:10 PM
ExcelPatient ExcelPatient is offline Mac OS X Office 2008 for Mac
Novice
  
Join Date: Nov 2016
Posts: 3
ExcelPatient is on a distinguished road
Default If (cell) is (range of cells), then (cell) should be (range of cells)
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
Reply With Quote