SOLVED

How to auto-populate several different formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1858218%22%20slang%3D%22en-US%22%3EHow%20to%20auto-populate%20several%20different%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858218%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys!%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20auto%20populate%20different%20formulas%20into%20a%20cell%20depending%20on%20what%20is%20selected%20(from%20a%20drop%20down%20list)%20or%20entered%20into%20a%20previous%20cell%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20I%20have%204%20different%20sets%20of%20date%20(V104%2C%20V103.5%2C%20V155%2C%20V162)%2C%20which%20will%20be%20entered%20in%20cell%20B2%2C%20depending%20on%20which%20of%20these%204%20sets%20are%20selected%2C%20I%20would%20like%20a%20formula%20to%20auto%20populate%20into%20cell%20D2%20multiplying%20a%204%2C%203.5%2C%2055%2C%20or%20a%2062%20by%20whatever%20amount%20was%20entered%20in%20C2.%20(Screenshot1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20can%20be%20done%20singly%20cell%20by%20cell%20after%20the%20data%20is%20all%20entered.%20But%20I%20would%20like%20it%20to%20be%20automated%20if%20possible.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1858218%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-1858642%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20auto-populate%20several%20different%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858642%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F859117%22%20target%3D%22_blank%22%3E%40Ultra_Tech%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20is%20different%20logic%20in%20your%20post%20and%20the%20sample.%20Based%20on%20post%20we%20simply%20ignore%20V1%2C%20as%20variant%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%20447px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231783i58335CA6E1277598%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%0A%3CP%3EIn%20sample%20V104%20is%20transformed%20to%204%20and%20V162%20to%20162%2C%20the%20logic%20of%20that%20is%20not%20clear.%20Could%20you%20please%20sync%20and%20define%20the%20logic%20in%20more%20formal%20way.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1858830%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20auto-populate%20several%20different%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1858830%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3EApologies%20for%20the%20confusion.%20But%20you%20nailed%20it!%3C%2FP%3E%3CP%3EI%20was%20able%20to%20use%20that%20formula%20and%20just%20drag%20it%20down%20the%20entire%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20million!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi guys!

Is there a way to auto populate different formulas into a cell depending on what is selected (from a drop down list) or entered into a previous cell? 

 

For example, I have 4 different sets of date (V104, V103.5, V155, V162), which will be entered in cell B2, depending on which of these 4 sets are selected, I would like a formula to auto populate into cell D2 multiplying a 4, 3.5, 55, or a 62 by whatever amount was entered in C2. (Screenshot1)

 

I know this can be done singly cell by cell after the data is all entered. But I would like it to be automated if possible.  

 

Is it possible?

 

 

 

 

3 Replies
Highlighted
Best Response confirmed by Ultra_Tech (New Contributor)
Solution

@Ultra_Tech 

There is different logic in your post and the sample. Based on post we simply ignore V1, as variant

image.png

In sample V104 is transformed to 4 and V162 to 162, the logic of that is not clear. Could you please sync and define the logic in more formal way.

Highlighted

@Sergei Baklan 

Apologies for the confusion. But you nailed it!

I was able to use that formula and just drag it down the entire column.

 

Thanks a million!  

Highlighted

@Ultra_Tech , you are welcome