Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Tough Formula Question :-?

  1. #1
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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. #3
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you for the quick responses!

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    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. #7
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  8. #8
    Board Regular
    Join Date
    May 2002
    Posts
    52
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I still need an answer on the previous reply? Thanks for all your help. Roger.

  9. #9
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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,"?")


    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

  10. #10
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,006
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-08 15:04, miroj1 wrote:
    I still need an answer on the previous reply? Thanks for all your help. Roger.
    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," "),"?")

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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