If, or, if, or...

[joezeppy]

I keep forgetting my syntax in Excel (don't use it enough). I know this is easy; can someone help me to do the following?

if cell a2 = "Year" then show a1 times 12, if cell a2 = "Half Year" then show a1 times 6, if cell a2 = "Quarter" then show a1 times 3, if cell a2 = "Month" then show a1.

I know this is a great place for Excel help. Thanks in advance.

Joe

 

[Jonmo1]

Try

=A1*LOOKUP(A2,{"Half Year","Month","Quarter","Year"},{6,1,3,12})

 

[circledchicken]

Hi,

One option might be:
=A1 * LOOKUP(A2, {"Half Year","Month","Quarter","Year"}, {6,1,3,12})

Note that if you ever wanted to add further periods to the lookup_vector ({"Half Year","Month","Quarter","Year"}), it must be sorted in ascending order.