Sir,
A B C D
1 32 08 "Full"
2 31 08 "Pr"
3 32 07 "Th"
4 31 07 " "
5
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=" "
Please help me...
Bookmarks