So i am creating a spreadsheet and I need help a conversion that I need. I am looking to have a number that falls within a range of numbers, be converted into a numeric value in a different cell. The catch is that the range of numbers is decided by gender and age. For example:
A1 is gender
A2 is age
A3 is number that falls within a range of numbers
A4 is the score associated with all of that
Example:
A1: Gender (Male)
A2: Age (22)
A3: anything within 55 to 65 will give a certain score
A4: The actual score (100)
I hope this makes sense
A1 is gender
A2 is age
A3 is number that falls within a range of numbers
A4 is the score associated with all of that
Example:
A1: Gender (Male)
A2: Age (22)
A3: anything within 55 to 65 will give a certain score
A4: The actual score (100)
I hope this makes sense