8

I've got a string like

 ="Daily Avg: " &AVERAGE(C3:C13)

I'd like to be able to apply number formats within my cell's formula. Is this possible without custom scripts?

I've searched Google's help centre but found nothing.

11

The text() function might help you out. There is better documentation of it on the Excel help site: http://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspx

What you're looking for is wrapping your average() function in the text() function like this:

="Daily Avg: " &text(AVERAGE(C3:C13),"0.00")

text() works like this:

text(number,format) where number refers to the data you're trying to convert and format refers to the way you'd like numbers to be displayed. In my example I just carried out the decimal to 2 places.

3

The way you prepare the notation, makes me think of how I do it in MS Access.

In a Google spreadsheet you can also use the following straight forward formula:

=CONCAT("Daily Avg: ";FIXED(AVERAGE(C3:C13);2))
0

So, if you want to add a string with a variable or function then more string, here is the format:

="Text " &DATEDIF(DATE(2015,9,8), TODAY(), "D" )  &" text."

Notice that adding more components requires the &.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.