Combining multiple functions into one function

[coryjapan]

I have come up with 2 functions that I need to be combined into one. There are 3 drop down windows to choose from and the function answer should depend on what is chosen in each of the three drop down windows. These are the two formulas.

=IF($M$3<3,VLOOKUP($M$2,Freezer_Delco,2,TRUE),VLOOKUP($M$2,Freezer_RBD,2,TRUE))

This second formula is multiplying the answer from the first formula.

=IF($M$4=1,$G$31*2,IF($M$4=3,$G$31*0.69231,$G$31))

Is there any way to combine these 2 functions into one to get one answer in one cell?
Or do I have to place one answer in a hidden cell and place the final function where it needs to be displayed?

Thanks,
Cory

[martindwilson]

why not just

=IF($M$3<3,VLOOKUP($M$2,Freezer_Delco,2,TRUE),VLOOKUP($M$2,Freezer_RBD,2,TRUE))*IF($M$4=1,$G$31*2,IF($M$4=3,$G$31*0.69231,$G$31))