Conditional if statement

[Matt Stanley]

I have a spreadsheet that needs to calculate the annual cost of a service
based on whether the metric is weekly or monthly. For example, one column
has a flat rate; the next column has a pulldown list with the options
"Weekly" or "Monthly;" the last column is for annual cost. This last column
should check to see if the value of the second column is "Weekly" or
"Monthly" and calculate the annual cost accordingly... If it's weekly, then
the last column should multiply the first column by 52, but if it's monthly,
then the last column should multiple the first column by 12.

How do I do this???

TIA,
Stan

 

[Biff]

Hi!

Here's one way:

=IF(B1="","",IF(B1="Weekly",A1*52,A1*12))

Assume that the dropdown is in column B and the value to
multiply is in column A.

Biff