Welcome Guest
Log In | Register )
You last visited December 8, 2016, 10:57 am
All times shown are
Eastern Time (GMT-5:00)

excel formula help please

Topic closed. 2 replies. Last post 7 years ago by jester001.

Page 1 of 1
PrintE-mailLink
Avatar

Philippines
Member #67927
December 8, 2008
67 Posts
Offline
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.

    Avatar
    komotini
    Greece
    Member #72381
    March 16, 2009
    28 Posts
    Offline
    Posted: March 1, 2010, 4:47 pm - IP Logged

    put it in cell C1

    =IF(AND(A1<=4;A1>=0);"A";"B")

      Avatar

      Philippines
      Member #67927
      December 8, 2008
      67 Posts
      Offline
      Posted: March 1, 2010, 9:06 pm - IP Logged

      thanks alot sir. :)