help with annualising formula

[ajm]

folks, doing a budget. user has choice when entering income and bills as to the frequency. so, salary income might be fortnightly and dividend returns might be quarterly. the user will also be able to select the way they view the output. they may want to look at income as a yearly number or even fortnightly. The output format is for all income items. It does not mean that they can select different output frequency per item.

I am trying to figure out a formula that encompasses all the input variables and then allows for the output variables too. Is there a better way to do it than a large, potentially ugly IF statement. like if(QtrlyOutput, if(monthly input, ($$*12)/4,if(weekly input, ($$*52)/13, etc

 

[ajm]

i worked out something easier.

=IF($D5="","",$D5*INDEX(FreqTable,MATCH($E5,Frequency,FALSE),2)/INDEX(FreqTable,MATCH(F$3,Frequency,FALSE),3))

where
D5 is an amount of $$
FreqTable is a named range listing the Frequency of income/outgoing (col 1 is the Wkly, Ftly, Mthly, Qrtly, Annually, Col 2 and Col 3 have the divisible denominators ((number to divide by) for each frequency).

the formula then reads, if D5 is blank, give me blank

ELSE multiply D5 (the dollars) by the income frequency (to get an annualised amount) and then divide that by the desired display frequency

Hope that makes sense to others.