mercredi 20 janvier 2021

Is there a way to return value from an array if it is between two numbers?

Is there a way to fill in column B if the value in column A is between the numbers in column D and E? If the value is 41 then I want to return N/A since 41 is not in the range of numbers. Everything I tried just filled "Grape" since it was the closest and I don't want a long IF statement.

Data

Aucun commentaire:

Enregistrer un commentaire