using multiple IF conditions

[jobeirne]

Hi,

I have attached the file that I need help with. Cells D12-D16 and cells E12-E16, are drop down lists. I want to assign different amounts to different combinations of the menus. For example if the values stay as they are now in the drop down lists, the amounts to the right are correct but if I change the combinations in the drop down lists the amounts to the right should also change. Even if someone could put the correct IF statements, to reflect what is there now, I could work out the rest...

Please help. Thank you

[martindwilson]

duplicate post!
http://www.excelforum.com/excel-form...onditions.html