Multiple Choice

Hi back again!

Working on the same piece of work as in:

http://www.excelforum.com/excel-gene...n-formula.html

Howver this time i need to add in columns for whether the ship is moving or not and the speed of the wind.

Currently have this formula to calculate the kinetic energy fo the plane:

Please Login or Register  to view this content.

This basically says that if my dropdown says yes for ship speed then add that in, yes for wind add that in. However this doesnt work as if i click yes for ship speed then the formula stops there and doenst add wind. I could probably do this with a long formula containing AND() but i was wondering if there was an easier way, im lucky i only have two extra variables but if there were more this could get pretty tricky!

Thanks,

Max

You mean you want to add the separate IF's?

Please Login or Register  to view this content.