Drop Box automated calculations

@ ahh1214

As you don't say the calculations you're making, let's assume that:

if "New" is selected in L4, in M4 the formula had to be:

Please Login or Register  to view this content.

if "Old" is selected in L4, in M4 the formula had to be:

Please Login or Register  to view this content.

and if nothing is selected, you left M4 empty, then you can use:

Please Login or Register  to view this content.

In your other post you said that this is for a school project, so it wouldn't be right for us to solve the whole problem for you.

As vichopalacios has said, you need to use an IF statement to check if 'New' or 'Old' is selected, with the appropriate calculations for each option - you'll need to work out for yourself what those calculations are and how to fit them into the IF statement (hint - watch where you put your brackets if you have lots of them). His formula also sensibly deals with neither 'New' nor 'Old' being selected - this is basic 'error checking' which can make your spreadsheets look a lot cleaner.

Good luck.