IF I enter 01-09 in B10 or B11 or B12 want autofill FIRST in C10, C11, C12
11-19 in B10 or B11 or B12 want autofill SECOND in C10, C11, C12
20-29 in B10 or B11 or B12 want autofill THIRD in C10, C11, C12
HOW TO DO THIS ?
THANKS IN ADVANCE
IF I enter 01-09 in B10 or B11 or B12 want autofill FIRST in C10, C11, C12
11-19 in B10 or B11 or B12 want autofill SECOND in C10, C11, C12
20-29 in B10 or B11 or B12 want autofill THIRD in C10, C11, C12
HOW TO DO THIS ?
THANKS IN ADVANCE
Last edited by stephensraj; 08-17-2014 at 01:52 PM.
please attach with example
Please try the following formula in C10 and drag down. This would work provided B10 to B12 are formatted as text & not dates.
=IF(B10="01-09","FIRST",IF(B10="10-19","SECOND",IF(B10="20-29","THIRD","")))
See attach
another sample also value diffrent
Please use the following formula in C6 Sample.xlsx and drag down:
=IF(B6<=9,"FIRST",IF(B6<=19,"SECOND",IF(B6<=29,"THIRD","")))
Use the following formula in C2 Sample1.xlsx and drag down:
=IF(B2<50,"NA",IF(B2<60,"THIRD",IF(B2<70,"SECOND",IF(B2<85,"FIRST","HONOURS"))))
Its working Thanks.............
You are welcome
If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.
Also, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks