I want to make a formula that will convert standard state names to time
zones. I don't want to have to nest a whole bunch of if statements though,
is there any way to do this without a macro? Is it possible to set up an IF
statement that says =if(A1="WA" OR "CA" OR "another state") then = West
Coast. I don't need it to actually give me a time, just classify them by
time zone.

Thanks in advance!!!