AVERAGEIF With ROUNNDUP or CEILING Function

[jski21]

Good day Mr. Excel Team,

Using this formula with success:

=(AVERAGEIF(E17:P17,">0",E17:P17)*$U$4)

Basically averaging everything above zero and then multiplying by a factor ($U$$4).


Attempting to add a CEILING or ROUNDUP function but I keep getting a ""You've entered too few arguments" error:

=CEILING(AVERAGEIF(E17:P17,">0",E17:P17)*$U$4),100)


I've never combined these two functions previously...probably a minor oversight but would appreciate a look see and assistance. Thanks.



jski

 

[arthurbr]

You opened 2parenthesis and closed 3....
=CEILING((AVERAGEIF(E17:P17,">0",E17:P17)*$U$4),100)

 

[jski21]

Thought I did this already . Minor oversight was right. And so were you. Thanks arthurbr!

 

[arthurbr]

My pleasure