round numbers inside a concatenate formula?

[mcalice]

Here is my formula, and it works great except that the average number has too many decimals!

I just want to round it up to the nearest whole number.

I assume I should use ROUNDUP, but I'm not sure where to put it in the formula.


CONCATENATE("Actual Hours 31% or more under Estimate (",(AVERAGE($P$3:$P$1000)),")")


thanks for any help!!

-Alice

 

[Luke M]

The commas get a little confusing to me, so I switched to using the ampersand to concatenate:

="Actual Hours 31% or more under Estimate (" & ROUNDUP(AVERAGE($P$3:$P$1000),0) & ")"

 

[mcalice]

Oh WOW! So I don't even have to use the actual word concatenate?!

that's great, and it works perfectly!

Thank you for your help Luke!

 

[Luke M]

You're welcome. Yep, the CONCATENATE function is somewhat redundant and cumbersome. It's a somewhat long name (and I admit I sometimes misspell it) and it has a 30 string limit. Using ampersands is faster to type, and there's no limit.