Hiding or showing cells based on the option chosen in a drop down box

[hjane]

Hello!

I am trying to make a mortgage calculator and I'm ok with most of it but I'm hoping someone can help me with something I'm stuck on.

I need the user to choose what they are trying to find out. Either they want to find the amount they need to borrow or they want to find out the amount that their fortnightly repayments will be.

So I have made a drop down box with these options. Based on what the user chooses I need differnt information from them to make my calculations.

I'm not sure if this is possible but IDEALLY if the user wants to work out the size of their loan I would want a box to appear asking them to enter the amount they want their fortnightly payments to be. Alternatively if the user wants the calculator to work out the size of their fortnightly repayments I want a cell to appear asking them to enter them amount they want to borrow and the cell asking for the size of their repayments to disapear.

Is this even possible, or is there a solution I am missing?


Any help would be much appreciated, Thank you!