Hi guys

I am a complete newbie to this forum so please go easy.

I have created a drop down list on my spreadsheet with the the following: Yearly, Quarterly, Monthly, Fortnightly, Weekly, Daily

I have set up a cell so that when you select one of the above words, 2 numbers are multiplied and then multipled again by a 3rd number with the 3rd number being the only one that changes depending on what word from the list you choose

My problem is that for the first three words (Yearly, Quarterly, Monthly) everything works perfectly, with the correct result showing up in the cell but for the rest I get $0.00 but it shouldn't be

Here is the formula I am using:

=IF(F6="Yearly",(D6*E6)*'Budget Calc'!C2)+IF(F6="Quarterly",(D6*E6)*'Budget Calc'!C3)+IF(F6="Monthly",(D6*E6)*'Budget Calc'!C4)+IF(F6="Fortnightly",(D6*E6)*'Budget Calc'!C5)+IF(F6="Weekly",(D6*E6)*'Budget Calc'!C6)+IF(F6="Daily",(D6*E6)*'Budget Calc'!C7)

As you can see it is very repetitive so I am not sure why the last last 3 words dont produce the desired result.

Any help on this would be greatly appreciated

Thanks in advance

Se7en