HI, LOVE THE WEBSITE BUT I DO HAVE A QUESTION THAT RELATES TO THE FOLLOWING FORMULA:
=IF(A1<=12000,"Poor",IF(A1<=15000,"OK","Good"))
THIS WAS A NESTED FORMULA THAT YOU PUT TOGETHER FOR A COLLEGE STUDENT. LOOKING AT THE FORMULA TEXT IN PARENTHESIS ARE LISTED IF A CERTAIN NUMBER COMES UP.
MY QUESTION IS HOW CAN YOU DISPLAY A CONTENT OF A CELL RATHER THAN THE WORD “POOR” OR ‘GOOD’?
HERE IS THE FORMULA I AM TRYING TO CORRECT:
IF A1=B1,D5 …
IN OTHER WORDS IF THE VALUE (OR TEXT) IN CELL A1=THE VALUE(OR TEXT) IN CELL B1, I THEN WANT TO PRINT OUT THE VALUE IN CELL D5.
THANKS FOR THE TIME AND EFFORT!
ROGER
=IF(A1<=12000,"Poor",IF(A1<=15000,"OK","Good"))
THIS WAS A NESTED FORMULA THAT YOU PUT TOGETHER FOR A COLLEGE STUDENT. LOOKING AT THE FORMULA TEXT IN PARENTHESIS ARE LISTED IF A CERTAIN NUMBER COMES UP.
MY QUESTION IS HOW CAN YOU DISPLAY A CONTENT OF A CELL RATHER THAN THE WORD “POOR” OR ‘GOOD’?
HERE IS THE FORMULA I AM TRYING TO CORRECT:
IF A1=B1,D5 …
IN OTHER WORDS IF THE VALUE (OR TEXT) IN CELL A1=THE VALUE(OR TEXT) IN CELL B1, I THEN WANT TO PRINT OUT THE VALUE IN CELL D5.
THANKS FOR THE TIME AND EFFORT!
ROGER