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
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
Highlighted

@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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies