+ Reply to Thread
Results 1 to 10 of 10

If the cells is equal to "A or NA" then show a message

  1. #1
    Registered User
    Join Date
    03-17-2013
    Location
    Cardiff
    MS-Off Ver
    Excel 2010
    Posts
    3

    Post If the cells is equal to "A or NA" then show a message

    Hey,

    I am trying to create a grading sheet for my college work,
    I am trying to see if the cell is equal to A(achieved) or na(not applicable) to show the message "finished", and if they are not met show "Not finished".

    Here's the code i have already done.

    Please Login or Register  to view this content.
    If you could help me that would be brill!
    Thanks in Advance
    Chris x

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If the cells is equal to "A or NA" then show a message

    Hi Chris,

    welcome to the forum.
    You formula should work if you remove ":R4" portion from there.. and when done, copy the formula down.

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: If the cells is equal to "A or NA" then show a message

    is that a cell or a range of cells?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: If the cells is equal to "A or NA" then show a message

    not sure what you are looking for but
    say in C5:
    =IF(OR(C4="a", C4="na"),"Finished","Not Finished!")
    and drag across to R5

    will put the results under the grade cells
    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  5. #5
    Registered User
    Join Date
    03-17-2013
    Location
    Cardiff
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: If the cells is equal to "A or NA" then show a message

    Quote Originally Posted by martindwilson View Post
    is that a cell or a range of cells?
    Yes that is the range of cells, I want it to show the message "finished" if all the cells either contain A or NA.

    If you understand?
    Not just one cell

    Thanks
    Chris x

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If the cells is equal to "A or NA" then show a message

    I want it to show the message "finished" if all the cells either contain A or NA.
    Use below formula:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    03-17-2013
    Location
    Cardiff
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: If the cells is equal to "A or NA" then show a message

    Quote Originally Posted by dilipandey View Post
    Use below formula:-
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards,
    DILIPandey
    <click on below * if this helps>
    Thank you so much! it worked a treat!

    Thanks again!
    Chris x

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If the cells is equal to "A or NA" then show a message

    see the sample workbook which I used :-

    sample - range contains a or na.xlsx


    Regards,
    DILIPandey
    <click on below * if this helps>

  9. #9
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: If the cells is equal to "A or NA" then show a message

    Great...!!


    Please mark this thread as [SOLVED]..thx

    Regards,
    DILIPandey
    <click on below * if this helps>

  10. #10
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: If the cells is equal to "A or NA" then show a message

    Try:
    =IF(COUNTIF(C4:R4,"A")+COUNTIF(C4:R4,"NA")=COLUMNS(C4:R4),"Finished","Not Finished!")
    or
    =IF(SUMPRODUCT((C4:R4="a")+(C4:R4="na"))=COLUMNS(C4:R4),"Finished","Not Finished!")

    Hope this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1