Thanks:  0
Likes:  0

1. 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

2. 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.

=IF(A1=B1,D5,"?")

3. Boy that was quick, but let me take it one step further... what if I wanted to show the contents of 2 or more cells, for example d5 to d10 ? What do I type then?

[ This Message was edited by: miroj1 on 2002-05-07 23:35 ]

4. =IF(A1=B1,CONCATENATE(D5,d6,d7,d8,d9,10),"?")

5. Thank you for the quick responses!

6. On 2002-05-07 23:23, miroj1 wrote:
Boy that was quick, but let me take it one step further... what if I wanted to show the contents of 2 or more cells, for example d5 to d10 ? What do I type then?

[ This Message was edited by: miroj1 on 2002-05-07 23:35 ]
Depends on what you mean by: show the contents of 2 or more cells, for example d5 to d10? Do you want them sum, average, count...?

7. Well I thought it worked well until I tried the formula and instead of (e.g.) 45 65 32 54 62 17, I end up with 456532546217... how do I get those spaces in the result while using the formula:
=IF(D23=F23,CONCATENATE(G23, G24, G25, G26, G27, G28, G29, G30),"?")

Thanks again!

9. On 2002-05-08 14:58, miroj1 wrote:
Well I thought it worked well until I tried the formula and instead of (e.g.) 45 65 32 54 62 17, I end up with 456532546217... how do I get those spaces in the result while using the formula:
=IF(D23=F23,CONCATENATE(G23, G24, G25, G26, G27, G28, G29, G30),"?")

Thanks again!
The & below does the same as the concatenate but its much easier to use.

=IF(D23=F23,G23&" "&G24&" "&" "&G25&" "&G26&" "&G27&" "&G28&" "&G29&" "&G30,"?")

10. On 2002-05-08 15:04, miroj1 wrote:
OK, since you want to concatenate the contents of a range of consecutive cells, you could use MCONCAT from the add-in Morefunc, downloadable from:

http://longre.free.fr/english/index.html

After adding in Morefunc, you can have:

=IF(D23=F23,MCONCAT(G23:G30," "),"?")

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•