Get the equation, extended use of formulatext?

%3CLINGO-SUB%20id%3D%22lingo-sub-2067113%22%20slang%3D%22en-US%22%3EGet%20the%20equation%2C%20extended%20use%20of%20formulatext%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067113%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI've%20uploaded%20the%20spreadsheet%20for%20clarity.%20I'm%20looking%20for%20a%20specific%20answers%2C%20so%20please%20read%20carefully.%3C%2FP%3E%3CP%3EI%20want%20to%20get%20the%20equations%20used%20in%20a%20cell.%20I%20would%20like%20to%20know%20how%20to%20either%3A%3C%2FP%3E%3CUL%3E%3CLI%3EReplace%20all%20cell%20references%20with%20the%20variable%20name%20(ie.%20change%20the%20formula%20in%20B32%20to%20Calculated_Velocity*convert%20so%20formulatext%20in%20shows%20variable%20names%3C%2FLI%3E%3CLI%3EAdd%20functions%20to%20formulatext%20to%20return%20result%20with%20either%3CUL%3E%3CLI%3Ethe%20cell%20references%20(B31*B21)%20replaced%20with%20the%20cell%20name%20(%3DCalculated_Velocity*convert)%20or%3C%2FLI%3E%3CLI%3Ecell%20references%20(B31)%20replaced%20with%20the%20VALUE%20in%20the%20%22Variable%22%20column%20(%3DV_s1*convert)%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2067113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067162%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20equation%2C%20extended%20use%20of%20formulatext%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931523%22%20target%3D%22_blank%22%3E%40mksodland%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESince%20all%20your%20formulas%20are%20in%20one%20sheet%20you%20may%20use%20Apply%20Names%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20324px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246931i2B55E07D048C2085%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067163%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20equation%2C%20extended%20use%20of%20formulatext%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F931523%22%20target%3D%22_blank%22%3E%40mksodland%3C%2FA%3E%26nbsp%3BPerhaps%20like%20int%20he%20attached%20file%3F%20Selected%20the%20entire%20table%2C%20and%20%22Applied%22%20all%20names%20from%20the%20Name%20Manager.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2067480%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20the%20equation%2C%20extended%20use%20of%20formulatext%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2067480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20do%20you%20know%20how%20to%20automatically%20name%20a%20cell%20the%20name%20given%20to%20the%20right%20as%20it%20is%20being%20added%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%2C%20when%20I%20add%20a%20new%20row%20to%20the%20table%2C%20the%20cell%20in%20BNew%20is%20named%20the%20value%20in%20Anew%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

I've uploaded the spreadsheet for clarity. I'm looking for a specific answers, so please read carefully.

I want to get the equations used in a cell. I would like to know how to either:

  • Replace all cell references with the variable name (ie. change the formula in B32 to Calculated_Velocity*convert so formulatext in shows variable names
  • Add functions to formulatext to return result with either
    • the cell references (B31*B21) replaced with the cell name (=Calculated_Velocity*convert) or
    • cell references (B31) replaced with the VALUE in the "Variable" column (=V_s1*convert) 

 

5 Replies

@mksodland 

Since all your formulas are in one sheet you may use Apply Names

image.png

@mksodland Perhaps like int he attached file? Selected the entire table, and "Applied" all names from the Name Manager.

@Sergei Baklan @Riny_van_Eekelen 

Thank you both so much!! The screenshot really helped because I didn't realize I have to highlight all the names (but replace them manually one by one) when I tried that the first time. I noticed that shift+ click top and bottom (nor ctrl+) didn't work, and now that they are all highlighted (by shift+ click individually), I don't want to ruin it to test alternatives like alt+a.

 

Do you also know how to highlight all at once?

@Riny_van_Eekelen @Sergei Baklan 

 

Also, do you know how to automatically name a cell the name given to the right as it is being added? 

 

Like, when I add a new row to the table, the cell in BNew is named the value in Anew?

@mksodland 

Unfortunately I don't know an answer on both your questions.

Highlighting - click/or "+" /or "-" buttons one by one, Ctrl and Shift affect nothing

Automatic naming - not if it exists with standard tools

 

In general related to names boxed were made ages ago and practically never modified, I'd do not expect advanced functionality in this interface.