Forum Discussion
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!
Hope this will help you.
Was the answer useful? Mark as best response and Like it!
This will help all forum participants.
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.
