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

[jobeirne]

=IF(AND(D12="16 GB",D13="200 GB",D14="100 GB",D15="2 TB",D16="Linux",E12="64 GB",E13="500 GB",E14="100 GB",E15="2 TB",E16="Linux"),"1214.38","not available")

This is the statement Im trying to make work. It works with what is there but i dont know what to change the formula to if i change any of the drop down figures

[martindwilson]

what amounts to the right? where is this formula going to go?

[Fotis1991]

You were almost there.

=IF(AND(D12="16 GB",D13="200 GB",D14="100 GB",D15="2 TB",D16="Linux",E12="64 GB",E13="500 GB",E14="100 GB",E15="2 TB",E16="Linux"),1,214.38)

[martindwilson]

well that as it maybe but it looks as op wants different amounts for different combinations. i think setting up a table with the required combinations then concatenating the results of each row then a index/match or vlookup could be used

[jobeirne]

sorry I had the wrong file uploaded. It the right one now

[martindwilson]

still cant understand it ,how is the figure derived,but your upload is not in this thread its in the other one you started!

[jobeirne]

@ martin, I have the figures the different combinations make. As part of a college assignment (worth 100% of module), we need to create a tool in excel, using what if analysis to compare the results of different cloud computing providers.... I dont know how to go about it

[Fotis1991]

I Just modified a little your formula(As i already told)

[martindwilson]

ah whatif analysis is a whole different ball game, that's a seperate thing on the data tab. not up on that i'm afraid
@fotis what is the result if d12= 64gb i'm sure a different price is required
i suspect there's a different price for each component according to which company sells it

[jobeirne]

@martin. Thanks for your help. So Ive been approaching this all wrong I think. Back to the drawing board *sigh*

[Fotis1991]

ah whatif analysis is a whole different ball game, that's a seperate thing on the data tab. not up on that i'm afraid
@fotis what is the result if d12= 64gb i'm sure a different price is required
i suspect there's a different price for each component according to which company sells it

Agree Martin.

I thouht that i used invisible ink, until i saw your message