+ Reply to Thread
Results 1 to 6 of 6

i want formula check cell if cell is blank go to next cell and check value and give grades

  1. 06-19-2017, 07:15 AM #1
    pksrikanth85
    pksrikanth85 is offline
    Registered User
    Join Date
    06-19-2017
    Location
    Srilanka
    MS-Off Ver
    2010
    Posts
    3

    Question i want formula check cell if cell is blank go to next cell and check value and give grades

    i want formula check cell if cell is blank go to next cell and check value and give grades..........

    =IF(OR(AB=" ",(AC=" ",(AD=" ",(AB7<=34,"W",IF(AB7<=49,"S",IF(AB7<=64,"C",IF(AB7<=74,"B",IF(AB7<=100,"A"))))),(AC7<=34,"W",IF(AC7<=49,"S",IF(AC7<=64,"C",IF(AC7<=74,"B",IF(AC7<=100,"A"))))),(AD7<=34,"W",IF(AD7<=49,"S",IF(AD7<=64,"C",IF(AD7<=74,"B",IF(AD7<=100,"A"))))),"AB"))))
    Reply With QuoteRegister To Reply
  2. 06-19-2017, 08:21 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: i want formula check cell if cell is blank go to next cell and check value and give gr

    Your logic is all messed up in that formula, some of the references are not even proper cells references!

    Try this
    =IF(AB7&AC7&Ad7="","AB",LOOKUP(IF(AB7<>"",AB7,IF(AC7<>"",AC7,AD7)),{34,49,64,74,100},{"W","S","C","B","A"}))
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 06-19-2017, 09:22 AM #3
    pksrikanth85
    pksrikanth85 is offline
    Registered User
    Join Date
    06-19-2017
    Location
    Srilanka
    MS-Off Ver
    2010
    Posts
    3

    Re: i want formula check cell if cell is blank go to next cell and check value and give gr

    Thank you. but I need some more.

    New Picture (4).jpg

    Please help...........
    Last edited by pksrikanth85; 06-19-2017 at 09:37 AM.
    Reply With QuoteRegister To Reply
  4. 06-19-2017, 10:15 AM #4
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: i want formula check cell if cell is blank go to next cell and check value and give gr

    Assuming that the data from post #3 is in columns A:C with the formula in D1, try

    D1 =IF(COUNTIF(A1:C1,"AB"),"AB",LOOKUP(SUM(A1:C1),{0,35,50,65,75},{"W","S","C","B","A"}))

    See attached.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-19-2017, 12:36 PM #5
    pksrikanth85
    pksrikanth85 is offline
    Registered User
    Join Date
    06-19-2017
    Location
    Srilanka
    MS-Off Ver
    2010
    Posts
    3

    Re: i want formula check cell if cell is blank go to next cell and check value and give gr

    Thank you very much.........
    Reply With QuoteRegister To Reply
  6. 06-19-2017, 12:42 PM #6
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: i want formula check cell if cell is blank go to next cell and check value and give gr

    You're welcome. Glad we could help!

    If that solved your question, please mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to check if a cell is blank then run another formula
    By Parky63 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2016, 11:56 AM
  2. [SOLVED] a forumla to check sum of letters and give a result and change cell colour?
    By Delinquent in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 11-18-2015, 09:26 AM
  3. [SOLVED] Check cell to see if blank if so move value from next column in to the cell.
    By Richard_Thornton in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2014, 06:19 AM
  4. [SOLVED] Formula needs to check if it equates to zero and return a blank cell
    By john dalton in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-20-2014, 12:03 PM
  5. Check if Blank, If so, Check the Next Cell
    By Watterboy in forum Excel General
    Replies: 5
    Last Post: 12-08-2011, 01:39 PM
  6. Check if any cell is blank.
    By spqr in forum Excel General
    Replies: 5
    Last Post: 06-18-2009, 04:29 AM
  7. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1