https://www.lotterypost.com/thread/209802 Lottery Post Forum Topic: excel formula help please en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/209802/1571435 https://www.lotterypost.com/thread/209802/1571435 Tue, 02 Mar 2010 02:06:11 GMT jester001 thanks alot sir.

]]> jester001 https://www.lotterypost.com/thread/209802/1571149 https://www.lotterypost.com/thread/209802/1571149 Mon, 01 Mar 2010 21:47:50 GMT alikirca20 put it in cell C1

=IF(AND(A1 =4;A1 =0); A ; B

]]> alikirca20 https://www.lotterypost.com/thread/209802 https://www.lotterypost.com/thread/209802 Mon, 01 Mar 2010 16:09:41 GMT jester001 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.

]]> jester001