If statement for timezones

S

Still Learning

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!!!
 
D

daddylonglegs

Set up a table, e.g. state abbreviations in Y2:Y50, asociated time zone name
in Z2:Z50 then use the formula

=VLOOKUP(A1,$Y$2:$Z$50,2,0)

to return the timezone name where a specific state abbreviation is contained
in A1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top