Hello
I'm trying to make a budget planner that converts each expense into the cost per fortnight (two weeks).
The cells are as follows:
C3 - Expense
D3 - Expense amount
E3 - Expense frequency (dropdown list)
F3 - Formula cell (conversion to fortnightly cost)
I want the user to input the amount in D3 and select the frequency from the dropdown list in E3.
I want F3 to read the value in E3 and then display the converted amount based on the two inputs.
Example:
------- C3 -----------D3-------E3--------F3----
Phone & Internet | $100 | Monthly | $46.15
OK, so the formula I'm using works when there are 3 or less IF arguments, however doesn't work for 4+ IF arguments because Excel reads the 4th/5th/6th argument as part of the first IF argument and returns the 'too many arguments' error.
How do I set out the formula so that it reads only what it needs to for each IF function?
This is my formula:
IF(E3="Weekly",D3*2, IF(E3="Fortnightly",D3, IF(E3="Monthly",(D3*12)/26, IF(E3="Quarterly",(D3*4)/26), IF(E3="6 Months",(D3*2)/26, IF(E3="Yearly",D3/26))))))
This formula works perfectly:
IF(E3="Weekly",D3*2, IF(E3="Fortnightly",D3, IF(E3="Monthly",(D3*12)/26)))
Bookmarks