You’re offline. This is a read only version of the page.
2
Imagine I have a table that looks like the following:
| Col A | Col B | Col C | Col D |
| Bonus | Data | 35 | 35 |
| Bonus | Data | 45 | 45 |
| Salary | Data | 55 | 62.59 |
| Salary | Data | 85 | 96.73 |
| Holiday | Data | 25 | 25 |
I would like to add a column (Col D) which performs a multiplication of Col C (* 1.138), but only if Col A contains a specific word, for example "salary", if it doesn't then the total should remain the same. Is this possible please? Thank you in advance.
Share
Report
All responses (
Answers (
