How to create multiple excel formula in one cell relative to data in another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3115473%22%20slang%3D%22en-US%22%3EHow%20to%20create%20multiple%20excel%20formula%20in%20one%20cell%20relative%20to%20data%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3115473%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20team%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%202%20excel%20tabs%20in%20one%20sheet%20(TAB%20A%20%26amp%3B%20TAB%20B)%3CBR%20%2F%3Eone%20tab%20(TAB%20A)%20has%20the%20values%20already%20inserted.%3CBR%20%2F%3Eanother%20tab%20(TAB%20B)%20has%20the%20required%20calculations.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20created%20a%20column%20in%20TAB%20B%20with%20a%20drop-down%20list%20relatable%20to%20values%20in%20a%20column%20from%20TAB%20A.%3CBR%20%2F%3EI%20want%20another%20cell%20in%20TAB%20B%20that%20will%20auto%20compute%20values%20dependent%20on%20each%20selection%20made%20off%20the%20drop-down%20list.%3CBR%20%2F%3EI%20believe%20IF%20and%20OR%20functions%20are%20applicable%20but%20i%20don't%20know%20where%20to%20start%20from.%20Thanks%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3115473%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3115534%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20multiple%20excel%20formula%20in%20one%20cell%20relative%20to%20data%20in%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3115534%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296918%22%20target%3D%22_blank%22%3E%40redgold%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20you%20could%20upload%20an%20example%20file%20here%2C%20it%20would%20be%20much%20easier%20for%20us%20to%20provide%20a%20proper%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello team

I have 2 excel tabs in one sheet (TAB A & TAB B)
one tab (TAB A) has the values already inserted.
another tab (TAB B) has the required calculations.

I have created a column in TAB B with a drop-down list relatable to values in a column from TAB A.
I want another cell in TAB B that will auto compute values dependent on each selection made off the drop-down list.
I believe IF and OR functions are applicable but i don't know where to start from. Thanks

1 Reply

Hi @redgold 

 

maybe you could upload an example file here, it would be much easier for us to provide a proper solution.