Forum Discussion
Fred Richardson
Feb 25, 2018Copper Contributor
Changing a cell's formula based on the value of another cell
I need to make a cell on my worksheet (U9) reflect a different formula based on the name from a drop down list in cell D9 (example, If D9 is "Bob", I want U9 to calculate "F9*.4", but if it's anyone ...
SergeiBaklan
Feb 25, 2018Diamond Contributor
Hi Fred,
=F9*IF(D9="Bob",0.4,0.25)