Respected Experts,
as shown below in my excel file the Cell E & F contains the value in Number and Text
and there is formula in Cell H for the Result..
..... E..... F...... H.....
1.... 32....08.... "F"
2.... 31....08.... "P"
3.... 32....07.... "T"
4.... 31....07.... " "
5.... AA....08.... "P"
6.... 32....AA.... "T"
7.... AA....AA.... " "
BUT....
As shown above in the Cell 'H' I need the value that,
if Cell E1 is greater than or equal to 32 and F1 is greater than or equal to 08, then show H1="F";
if Cell E1 is less than 32 and F1 is greater than or equal 08, then show H1="P";
if Cell E1 is greater than or equal to 32 and F1 is less than 08, then show H1="T";
if Cell E1 is less than 32 and F1 is less than 08, then show H1=" "
so also if either E1 or F1 cell is contains Text value then result must be shown as;
if Cell E1 is Text value and F1 is greater than or equal 08, then show H1="P";
if Cell E1 is greater than or equal to 32 and F1 is Text Value, then show H1="T";
and if both cell contains Text Value than H1=" "
Thanks in advance...
Bookmarks