+ Reply to Thread
Results 1 to 17 of 17

Return value cannot skip blank cell

  1. #1
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Return value cannot skip blank cell

    Hi all,

    I'm using following formula to compare input value with
    high and low limit.

    Please Login or Register  to view this content.

    My problem is when there's only 1 input data available,
    the return value will show nothing (OK or NG). It'll
    only return value when the second cell been input with "-".

    I need the return value to show OK or NG even when there's
    only 1 input .

    Please refer to attached file for details.

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    Hi, this was not too bad... after I cleared out all of the merged cells. If you need to make a cell wider, grab the column border at the top of the sheet, click & drag. Merged cells will cause endless difficulties for you... Use with care and (preferably) never. They're Ok for headers, but not so nice in data rows. Anyhow...

    try this:
    Attached Files Attached Files
    Glenn



  3. #3
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    Dear Glenn,

    Thank you for your advise. However, I really need this merged cell.
    But I will try to "center across selection" the cell (can't change the cell width).

    And I faced one problem with the function :
    If only 1 cell input with "within limit" value (eg. 200),
    it return "NG". Can u help me on this ?

    Thank you again
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    I am not clear about your requirement.

    If one value is inside tolerance and one value is outside tolerance, what result do you want?

  5. #5
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    Dear Glenn,
    The function work fine if the input value is 2 pcs. But i also need it to work if there's only 1 pc of input value.
    FYI, this function is for a daily check sheet. Sometimes the inspect part is only 1 pc, & sometimes 2 pcs.( not always 2 pcs).

    For ur question :

    "If one value is inside tolerance and one value is outside tolerance, what result do you want?"

    The return value is NG

    Sorry if ur not clear about my requirement. Really appreciate ur help, Tq


    Sent from my iPhone using Tapatalk
    Last edited by namialus; 07-06-2014 at 09:52 AM.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Return value cannot skip blank cell

    @namialus

    Please Login or Register  to view this content.
    Not seeing your data, but you could better believe Glenn, since you get in trouble with merged cells, sooner or later.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  7. #7
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    Dear oeldere,
    Thanks for ur advise too, actually i already changed it to "center across selection" format , thanks again


    Sent from my iPhone using Tapatalk

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    One more q...

    If there is just one value and it is in specification, what do you want it to return - OK or NG?

  9. #9
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    Ignore; accidental duplicate...

  10. #10
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    OK

    TQ


    Sent from my iPhone using Tapatalk

  11. #11
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    I want it to return "OK" .

    Thank you

  12. #12
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    I had change the formula so that when no input value, there will be no return value

    Please Login or Register  to view this content.
    But how can I make the return value automatically come out at 1st input in B17 (not until 2nd input in C17).

    Thank you
    Attached Files Attached Files

  13. #13
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Return value cannot skip blank cell

    If you only want to check on B17 you can use this formula.

    Please Login or Register  to view this content.

  14. #14
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    Hi. I apologies... I completely forgot about you. I never answered your reply at posts 10 & 11. Well, I've sorted them out, but I am not completely sure if I understand what you were asking in post 12.

    first of all, ake a look at this and see if it resolves the earlier posts. Then try to explain what more you need to have done to finish the job.
    Attached Files Attached Files

  15. #15
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    Dear oeldere,

    Thank you for your reply. However this is not what I meant. The C17 (2nd data) will also have input, but not the same
    time with B17 (1st data).

    Thank you again for your suggestion

  16. #16
    Forum Contributor
    Join Date
    11-29-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    106

    Re: Return value cannot skip blank cell

    Dear Glenn,

    Thank you for your reply. Your solution met my request. That is what I meant.
    Sorry if you can't understand my question at the first place.


    Thank you again

  17. #17
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2302
    Posts
    38,637

    Re: Return value cannot skip blank cell

    Thank you.. glad I was able to sort it out for you... eventually!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concatenate, Skip Blanks and Carriage Return only after non-blank
    By GTide in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2014, 05:08 PM
  2. VBA to skip if certain cell is blank
    By playtowinpb@msn.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2011, 08:30 AM
  3. Skip Blank Cell and Go To Next Row
    By AnskyCJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2010, 07:37 PM
  4. How to skip blank tabs of cell while using macro
    By bhagwat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-03-2009, 06:28 AM
  5. How do I skip a blank cell within macro?
    By DJ Dusty in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2006, 07:20 PM

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