Hello,
I am having trouble getting the IF function to work! I am trying to to input numbers into a cell automatically when a certain cell has a text input selected from a list that I have set up using cell validation. Here is a copy of what I have tried so far, once I get this to work, there will be 10 different selections, and I will have another IF function in an adjacent cell with about 34 nested IF statements.
=IF(K3="Overhead","0",IF(K3="Preliminary","1",IF(K3="Production","2",IF(K3="Construction","3"))))
I have tried this several ways, without the quotation marks, and with brackets and so on, I am tired and stumped - Please, HELP!!!!!!!
I can load a copy of my spread sheet if that will help, I am also using Excel 2003.
Thanks,
Matt
Bookmarks