If (cell) is (range of cells), then (cell) should be (range of cells)

ExcelPatient · #1 11-06-2016, 08:10 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Search Range Within Cell or Cells	COEngineer	Excel	1	06-01-2016 11:50 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
Count range cells eliminating merge cells	danbenedek	Excel	0	06-15-2010 12:40 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM