split cells with each having a formula possible?

[drb]

Want data table cell with the maximum and minimum values of another page to
show as a/b in a cell. Is this possible?

 

[Tyro]

Don't have a clue what you're talking about. Perhaps you could show an
example.

Tyro

 

[T. Valko]

A/B

A = max
B = min

=MAX(Sheet2!A1:A10)&"/"&MIN(Sheet2!A1:A10)

 

[drb]

Excellent, excellent. Exactly what I needed. THANK YOU.

 

[T. Valko]

You're welcome. Thanks for the feedback!