Need some help for those excel gurus out there.
I have a cell (A1) with a drop down list of items (4 items non-numerical). In another cell (A2), I want to be able to do a calculation based on the selection made in cell A1. What function do I use to be able to do this?
For instance, A1 - pick red, blue, green, or yellow.
In A2 - if red, then do this. if blue, then do this..and so on.
Can someone help me out? Is this the if..then function??