Aug 27 2019 05:55 PM
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
Aug 27 2019 07:45 PM
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
Aug 27 2019 08:38 PM
If the option is stored in A2, the formula for the price in B2 can be:
=IFERROR(LOOKUP(A2,
{"Client","Storage"},
{60,44}),
"")