Good Morning! I would like to know if it is possible to use an If and Then Statement for the following scenario:
Our employees get paid for driving from location to location. So if Brent travels to A to B that is 20 total miles. There are two cells (TO and FROM). These two cells have a list that Brent can select from (created the list by clicking Data > Validation > Criteria > List of items). When Brent selects the locations - I would like the total miles to go into another cell without Brent inputting it. So basically, if he travels to A to B 20 miles gets recorded. If he travels from B to C 25 miles gets recorded. Thanks! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
