SOLVED

Formula in exel

Copper Contributor

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 Hans Vogelaar (MVP)
Solution

@sanchez450 

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!

 

Hope this will help you.

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

This will help all forum participants.

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

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@sanchez450 

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!

 

Hope this will help you.

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

This will help all forum participants.

View solution in original post