(QUESTION) Molar Mass Calculator with drop-down list

**excel-tester** · 08-21-2013, 04:06 AM

Dear All,

Instead of using the mass molarity calculator from available companies such as: http://www.sigmaaldrich.com/chemistr...alculator.htmlI would like to create an excel sheet my self for offline uses.

Like the format in the link provided, I would like that a cell could swap between formula/calculation depending on the two drop-down list.
Something like this: Mass= formula A if drop-down 1 is liter & drop-down 2 is molar, or formula B if drop-down 1 is liter & drop-down 2 is molar.

I know I can do this if I create multiple cells with specific formula, but then the sheet wouldn't look so nice

If this is too difficult

to create then please let me know so i'll give up

Thank.

**FDibbins** · 08-21-2013, 10:37 AM

Hi and welcome to the forum

Something like this: Mass= formula A if drop-down 1 is liter & drop-down 2 is molar, or formula B if drop-down 1 is liter & drop-down 2 is molar.

I presume you meant liter/molar or molar/liter?

To create a formula based on whichever of those combinations are selected, you could use an IF() statement. Something like....
=if(A1=B1,"",if(and(A1="Liter",B1="Molar"),formula1,formula2))

the if(A1=B1,"", part is to take care of only 1 of the 2 D/D's being selected by mistake

**excel-tester** · 08-21-2013, 01:13 PM

Originally Posted by FDibbins

Hi and welcome to the forum

I presume you meant liter/molar or molar/liter?

To create a formula based on whichever of those combinations are selected, you could use an IF() statement. Something like....
=if(A1=B1,"",if(and(A1="Liter",B1="Molar"),formula1,formula2))

the if(A1=B1,"", part is to take care of only 1 of the 2 D/D's being selected by mistake

Thanks FDibbins, I will certainly give this a try.

23/8/13

got it working. Thank you FDibbins.

My formula for now is =IF(AND(C6=G12,C7=H12),B7*B6*B5,IF(AND(C6=G13,C7=H12),B7*(B6/1000)*B5,0))
I will have to create 7 more scenarios, but which is easy now that I know how to use the IF function.