Your formula for the result cell should look something like this: =IF(ISBLANK(<cellbrentpicks>),"",IF(<cellnbrentpicks="A to B",20,25))
On Thursday, July 11, 2013 8:05:27 AM UTC-5, Blair Carter wrote: > > 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.
