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 ...
neilm1 Alternatively, try this:
=SWITCH(I6,"AS", "Assemblies","EA", "EACH", "PI", "Installs", "Enter Unit")