Display formula results as values within formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1443430%22%20slang%3D%22en-US%22%3EDisplay%20formula%20results%20as%20values%20within%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443430%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wondered%20if%20I%20asked%20excel%20to%20add%20A1%2BA2%2BA3%3C%2FP%3E%3CP%3ELet's%20say%20those%20values%20are%3A%3C%2FP%3E%3CP%3EA1%20%3D%201%3C%2FP%3E%3CP%3EA2%20%3D%202%3C%2FP%3E%3CP%3EA3%20%3D%203%3C%2FP%3E%3CP%3ESo%20the%20result%20would%20be%206%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20what%20if%20I%20want%20excel%20to%20spell%20it%20out%20within%20the%20cell%20now%3A%3C%2FP%3E%3CP%3E%3D1%2B2%2B3%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20convert%20those%20linked%20formula%20into%20values%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1443430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1443598%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20formula%20results%20as%20values%20within%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1443598%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690403%22%20target%3D%22_blank%22%3E%40Rdenney%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20concrete%20this%20formula%20it%20could%20be%20parsed%20and%20calculated.%20For%20more%20abstract%20case%20and%20more%20complex%20formulas%20you%20may%3C%2FP%3E%0A%3CP%3E1)%20enter%20it%20as%20text%20into%20any%20cell%3C%2FP%3E%0A%3CP%3E2)%20create%20named%20formula%20for%20EVALUATE%20this%20cell%3C%2FP%3E%0A%3CP%3E3)%20calculate%20this%20named%20formula%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%20543px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F196772iA439893B6201DC9D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EOf%20course%2C%20you%20always%20may%20use%20VBA%20programming%20and%20to%20create%20your%20own%20function(s)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445241%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20formula%20results%20as%20values%20within%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690403%22%20target%3D%22_blank%22%3E%40Rdenney%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3F%3F%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Abiola1_0-1591449732143.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F197017iC2185865BFFB569E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Abiola1_0-1591449732143.png%22%20alt%3D%22Abiola1_0-1591449732143.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I wondered if I asked excel to add A1+A2+A3

Let's say those values are:

A1 = 1

A2 = 2

A3 = 3

So the result would be 6

 

But what if I want excel to spell it out within the cell now:

=1+2+3

 

Is there a way to convert those linked formula into values?

2 Replies
Highlighted

@Rdenney 

If concrete this formula it could be parsed and calculated. For more abstract case and more complex formulas you may

1) enter it as text into any cell

2) create named formula for EVALUATE this cell

3) calculate this named formula

image.png

Of course, you always may use VBA programming and to create your own function(s)

Highlighted