Changing a formula when a certain company is used

[Closed]
Report
-
Hello,

I am curious if anyone knows if there is a way to have excel change a formula when a certain word is used, and only change the formula in the cell next to that word? Leaving the other formulas in the pivot table the same?