G
Gil
i am trying to enter a formula that will return a specific number for
a range of numbers.
Example:
i know that if i have between a range of items, that i need to return
a specific number for that formula. if the number is between 0 and 53
it needs to return a 4, if the number is between 54 and 65 it needs to
return a 5 and so on.
i tried using lookup and choose, but i get errors in the
formula....this is the formula i used.
=LOOKUP(E45,{53,65,77,89,101,113,125,137,149,161,173},
{4,5,6,7,8,9,10,11})
E45 is the cell with the calculated value that now needs to be checked
to return the number i am looking for.
in this case, E45 has a 35 in it, so the formula should return a 4,
but instead i get a #N/A
a range of numbers.
Example:
i know that if i have between a range of items, that i need to return
a specific number for that formula. if the number is between 0 and 53
it needs to return a 4, if the number is between 54 and 65 it needs to
return a 5 and so on.
i tried using lookup and choose, but i get errors in the
formula....this is the formula i used.
=LOOKUP(E45,{53,65,77,89,101,113,125,137,149,161,173},
{4,5,6,7,8,9,10,11})
E45 is the cell with the calculated value that now needs to be checked
to return the number i am looking for.
in this case, E45 has a 35 in it, so the formula should return a 4,
but instead i get a #N/A