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

		Microsoft Office Forums > Microsoft Excel > Excel
If (cell) is (range of cells), then (cell) should be (range of cells)

11-08-2016, 07:21 AM

xor

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

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

=iferror(round(average(q5:q7),1),"")

=iferror(vlookup(q8,$b$38:$c$78,2,0),"")

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 AM.