Combining functions and text into one cell

[passion_to_be_free]

Ok, so I have this function repeated in a bunch of worksheets:

=MAX(F13:F94)&" min"

Sometimes I get the result I want "25 min" for example. But sometimes
I get "25.29384932345 min".
The range of cells are all calculated values, and the cells are set to
display the numbers with no decimal places.

Is there a way to combine the max function and the text without getting
all of the decimal places?

 

[JE McGimpsey]

Ok, so I have this function repeated in a bunch of worksheets:

=MAX(F13:F94)&" min"

Sometimes I get the result I want "25 min" for example. But sometimes
I get "25.29384932345 min".
The range of cells are all calculated values, and the cells are set to
display the numbers with no decimal places.

Is there a way to combine the max function and the text without getting
all of the decimal places?

Use the TEXT function:

=TEXT(MAX(F13:F94),"0 \min")

 

[passion_to_be_free]

Works like a charm...I didn't know about that function. Thanks again.

 

[passion_to_be_free]

Works like a charm...I didn't know about that function. Thanks again.