Solved cell =avg unless another cell is 1,

Microsoft Excel 2010 - complete product...
March 13, 2012 at 10:36:26
Specs: Windows 7
I am trying to show that a merged cell is equal to the average of cells N3 to N9 UNLESS cell K53 is =1, in that case the merged cell needs to =0.

See More: cell =avg unless another cell is 1,

Report •


#1
March 13, 2012 at 10:49:04
✔ Best Answer
Try:

=IF(K53=1,0,AVERAGE(N3:N9))

MIKE

http://www.skeptic.com/


Report •

#2
March 13, 2012 at 10:51:28
Perfect!!! Thank you so much!

Report •

Related Solutions


Ask Question