|Posted: March 1, 2010, 11:09 am - IP Logged|
hello i would like to ask for any help in making a formula for excel. the formula that i want is to substitute a number for cell A1 to cell C1 for example i have number from 0-9 and i divide it in two from 0-4 = A and 5-9 = B.
for example in cell A1 the number is 2 and i want to see in cell C1 the letter A and in A2 the number is 7 and i want to see in cell C2 the letter B is this possible? thanks alot to anyone who will help me.