display 1 value when 2 strings are the same, in a cell

[davidbananas999]

*** Figured it out already thanks anyway***






Is there a way to make something like

A1 = B2*B3 & " / " & (B2^2)/B4 & " / " & (B3^2)*B4

show 1200 instead of 1200 / 1200 / 1200 for example?

In my scenario, B1, B2, B3, and B4 are all (functions?) of each other so if I know 2 of those values, I can figure out the other 2. (meaning they will always give A1 the same value for X / X / X in my example)

---------------
different way to explain it just in case:

A1= B1 (and is also equal to) B2*B3 (and is also equal to) (B2^2)/B4 (and is also equal to) (B3^2)*B4
A2= B2
A3= B3
A4= B4

and give the number depending on which formula has the 2 values in order to solve for A1

I think i am making this more confusing than it needs to be, but thanks for the help

[FDibbins]

David, this thread is marked as SOLVED. Is that the case, and if so, can you share the answer? If not, mark ut UNsolved, or ask me (or a mod) to change it for you