I have a Google Form which will be used to register animals for a spay & neuter clinic. One of the questions is "Age".

I have multiple choices in Col A which include text. I want those choices to turn into numbers in Col B. I intend to report stats based on age groups in Col C.

1) Is there an easier way to set up the form so this gets calculated automatically? (English is a 2nd language here, so I can't rely on person entering too much)

2) Assuming no to #1 , I am bringing the responses into a Google Sheet where I can do formulas. What formula(s) do I use to get the responses from Col A into numbers like Col B?

Thanks, Andy

Row/Col | A | B | C | |

1 | Choices | # result | Stats to calc on | |

2 | wanted | |||

3 | 1 month | 0.08 | 6 months or under | |

4 | 2 months | 0.17 | 6+ months to 1 year | |

5 | 3 months | 0.25 | 1+ to 2 years | |

6 | 4 months | 0.33 | 2+ to 3 years | |

7 | 5 months | 0.42 | 3+ to 4 years | |

8 | 6 months | 0.50 | 4+ to 5 years | |

9 | 7 months | 0.58 | 5+ to 6 years | |

10 | 8 months | 0.67 | 6+ or older | |

11 | 9 months | 0.75 | ||

12 | 10 months | 0.83 | ||

13 | 11 months | 0.92 | ||

14 | 1 year | 1.00 | ||

15 | 1+ year | 1.01 | ||

16 | 2+ years | 2.01 | ||

17 | 3+ years | 3.01 | ||

18 | 4+ years | 4.01 | ||

19 | 5+ years | 5.01 | ||

20 | 6 years or older |
| ||