using a popup menu to change value in other cell

The conversions to weekly aren't exact and there are several ways to do them. For example, monthly-to-weekly conversion could be

Monthly/4 based on 4 weeks to a month (which is not true) or

Monthly*7/30 based on 360 days in a year =30 days in a month (which is not quite true) or

Monthly*7/(365/12) which is based on a 365 day year (which is not true 1/4 of the time).

None are quite right. I'm going to go with the 360 day year version that some financial functions use:

cell E2 =D2*IFS(A2="Weekly", 1, A2="Monthly", 7/30, A2="Quarterly",7/90,A2="Half Yearly", 7/180,"Yearly",7/360)

Hi brainfreeze87,

A week is the longest duration which is constant.

Months vary from 28, 29, 30, 31 days.

Years vary from 365 to 366 days.

Perhaps use 365.25 days in a year, which averages over a four year period to account for Leap Years. Again, this is approximate for any one year.

Regards,

Ian.

Looks good to me. Or use can use 365.25 like Yellowbox suggested. Whichever works best for you.