title: Google spreadsheet validation if statement
body: <p>I've used validation to create a drop down list of things that will require different values. So in the next column I want to create a formula that checks if anything has been selected in the list (otherwise show nothing e.g ""). Then if a certain item has been selected, multiply it by a certain value, say 2 and then display the total.</p>