Personalize function

Copper Contributor

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}),

"")