Sir,
A B C D
1 32 08 "Full"
2 31 08 "Pr"
3 32 07 "Th"
4 31 07 " "
5 AA 08 " "
6 32 AA " "
As shown above in the Cell 'C' I need the value that,
if A1 is greater than or equal to 32 and B1 is greater than or equal to 08, then show C1="Full";
if A1 is less than 32 and B1 is greater than or equal 08, then show C1="Pr";
if A1 is greater than or equal to 32 and B1 is less than 08, then show C1="Th";
if A1 is less than 32 and B1 is less than 08, then show C1=" "
so also if A1 or B1 cell is contains Text value then result must be shown C1=" "
PLEASE ASSUME a1 AND b1 CELL AS A EXAMPLE, I SET THE FORMULA IN BG2 AND NEXT CELLS
Please help me...
Bookmarks