SOLVED

Formula in exel

Copper Contributor

Formula in exel

I have a list of different services. I want to find a formula for all this services where for example when the service boss revolution to add 38, when vidapay add 58, att to add 50. Is there such thing. Thanks for the help

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

Re: Formula in exel

You can use the IF function in Excel to achieve this.

Here is an example formula:

=IF(A2="Boss Revolution", 38, IF(A2="Vidapay", 58, IF(A2="ATT", 50, 0)))

In this formula:

• A2 is the cell where you have the name of the service.
• "Boss Revolution", "Vidapay", and "ATT" are the service names you want to check for.
• 38, 58, and 50 are the values you want to add for each service.
• 0 is the default value if none of the service names match.

You can extend this formula with additional IF functions to include more services and their corresponding values as needed.Formularbeginn The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Re: Formula in exel

Thanks a lot for all your help. It was perfect.
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

Re: Formula in exel

You can use the IF function in Excel to achieve this.

Here is an example formula:

=IF(A2="Boss Revolution", 38, IF(A2="Vidapay", 58, IF(A2="ATT", 50, 0)))

In this formula:

• A2 is the cell where you have the name of the service.
• "Boss Revolution", "Vidapay", and "ATT" are the service names you want to check for.
• 38, 58, and 50 are the values you want to add for each service.
• 0 is the default value if none of the service names match.

You can extend this formula with additional IF functions to include more services and their corresponding values as needed.Formularbeginn The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!