Forum Discussion
If formula based on cell value
Not sure if an "IF" formula is the right one needed here, but this is what I am trying to do. In cell B9, I want text to display based on what is in cell I6. I have I6 set up as a list of one of the ...
Perhaps...
=IF(I6="","Select Unit",
IF(I6="AS","Assemblies",
IF(I6="EA","EACH",
IF(I6="PI","Installs",""))))