IF condition

[churmie]

I need help with what should be easy formula but I can't get it right. I have the following figures:

2

2

0

0

10

0

0

<tbody>
</tbody>

The average is 2, but I have a separate Formula which is a minimum of 2.5. How do I replace the zero values with whichever is higher of the average or the minimum?

thanks!

 

[AlanY]

Book1
	C	D	E	F	G	H	I	M	N	O	P	Q	R	S	T	U	V
1	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Min Stock	Average		Mon	Tue	Wed	Thu	Fri	Sat	Sun
2	2	2	0	0	10	0	0	2.5	4.7		2	2	4.7	4.7	10	4.7	4.7
Sheet1

Cell Formulas
Range	Formula
N2	=AVERAGEIF(C2:I2,">0",C2:I2)
P2	=IF(C2=0,MAX($N$2,$M$2),C2)