I need to find out how to use dashes/hyphens in an IF formula without Excel trying to treat them like a minus sign. Ex: if cell A1 says "blue", then I want cell A2 to say "799-69999-1" (exactly like this with the hyphens). However, cell A2 is showing -59301. How do I make the end result in cell A2 say "799-69999-1"? I also want to find a formula that will allow me to input multiple criteria. Ex: if cell A1 says blue, then cell A2 should be 799-99999-1. If cell A1 says red, then cell A2 should be 788-88888-1, etc. it would be up to 10 different criteria. Any help would be appreciated!