Home

Personalize function

%3CLINGO-SUB%20id%3D%22lingo-sub-825882%22%20slang%3D%22en-US%22%3EPersonalize%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825882%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20two%20options%2C%20if%20it%20is%20in%20storage%20the%20price%20is%2044%20but%20if%20it%20is%20to%20the%20client%20it%20is%2060%20so%20to%20a%20multiplication%20of%20two%20cells%20i%20have%20to%20add%20one%20of%20this%20actions%20either%20the%2044%20if%20it%20is%20going%20to%20storage%20or%2060%20if%20it%20is%20going%20to%20the%20client%2C%20how%20can%20i%20make%20a%20function%20to%20do%20this%20without%20doing%20it%20manually%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-825882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825913%22%20slang%3D%22en-US%22%3ERe%3A%20Personalize%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399327%22%20target%3D%22_blank%22%3E%40Daniela_Gomez%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20but%20the%20question%20isn't%20clear%20enough!%3C%2FP%3E%3CP%3EPlease%20provide%20a%20sample%20of%20the%20data%20you%20are%20working%20on%2C%20in%20order%20to%20understand%20the%20case%20and%20be%20able%20to%20provide%20the%20appropriate%20formula%20that%20fits%20with%20your%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825920%22%20slang%3D%22en-US%22%3ERe%3A%20Personalize%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F399327%22%20target%3D%22_blank%22%3E%40Daniela_Gomez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20option%20is%20stored%20in%20A2%2C%20the%20formula%20for%20the%20price%20in%20B2%20can%20be%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFERROR(LOOKUP(A2%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%7B%22Client%22%2C%22Storage%22%7D%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%7B60%2C44%7D)%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%22%22)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Daniela_Gomez
Occasional Visitor

I have two options, if it is in storage the price is 44 but if it is to the client it is 60 so to a multiplication of two cells i have to add one of this actions either the 44 if it is going to storage or 60 if it is going to the client, how can i make a function to do this without doing it manually 

2 Replies

@Daniela_Gomez

 

Hi,

 

Sorry, but the question isn't clear enough!

Please provide a sample of the data you are working on, in order to understand the case and be able to provide the appropriate formula that fits with your data.

 

Regards

@Daniela_Gomez 

If the option is stored in A2, the formula for the price in B2 can be: 

=IFERROR(LOOKUP(A2,

{"Client","Storage"},

{60,44}),

"")

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies