I have a cell range that calculates numeric values, how do I interpret the numeric value into a alpha value, with multiple conditions.
here is the range:
if(Cell value) is equal or greater then 8.5 then A,
and
if (Cell value) is greater then or equal to 7.5 and less then or equal to 8.0 then B.
and
if (Cell value) is greater then or equal to 6.5 and less then or equal to 7.0 then C.
and
if (Cell value) is less then or equal to 6.0 then D.
I have just registered to this website and currently searching the anals for a like solution; if someone can help, I would be very greatful,
thanks, Jim B
here is the range:
if(Cell value) is equal or greater then 8.5 then A,
and
if (Cell value) is greater then or equal to 7.5 and less then or equal to 8.0 then B.
and
if (Cell value) is greater then or equal to 6.5 and less then or equal to 7.0 then C.
and
if (Cell value) is less then or equal to 6.0 then D.
I have just registered to this website and currently searching the anals for a like solution; if someone can help, I would be very greatful,
thanks, Jim B