Silly Formiula Help Needed

[thescream80]

What I am looking to do is display 2 numbers in one cell.


Data Example -
F80001 = 16
D80001 = 35

Goal for it to look like - 16 / 4.571% / Right now it looks like - 0,016 / 4.571

Here is the formula that I am using

=TEXT(F80001,"0,000")&" / "&TEXT(F80001/D80001,"0.00%")*10

Thank you!!!

 

[Eric W]

Maybe:

=TEXT(F80001,"0,000")&" / "&TEXT(F80001/D80001/10,"0.00%")

 

[Fluff]

How about
=TEXT(L11,"#,##0")&" / " & TEXT(L11/L12/10,"0.000%")

 

[Gerald Higgins]

Bear in mind it's going to be very difficult (not impossible, but very difficult) to use the result of any such formula in another formula.

Consider returning each part of the result into separate cells, maybe formated so that they look the way you want.

 

[thescream80]

Thank you Fluff and Eric - those suggestions worked great!

 

[Eric W]

Glad we could help!