+ Reply to Thread
Results 1 to 3 of 3

IF/AND Correct Score Predictor - Blank Before Data Entry?

  1. #1
    Registered User
    Join Date
    01-19-2016
    Location
    Edinburgh
    MS-Off Ver
    Excel 2013
    Posts
    17

    IF/AND Correct Score Predictor - Blank Before Data Entry?

    Hi again everyone,

    Thanks for the guys that helped with the post I submitted the other day - managed to successfully get the formula working for scoring predicted scores.

    Predictor.png

    At the moment, however, since the predicted scores (column C and D) are blank and so are the actual scores to measure against (I & J), they are scoring them as a "correct score" with 5 points - what I want to be able to do is leave the score column blank until scores are entered in both the predicted column and the actual scores column. Is there anything I can add to the following formula to do this? Or is there any formatting I can do?

    =IF(OR((C4>D4)-(I4>J4);(C4<D4)-(I4<J4));0;IF(AND(C4=I4;D4=J4);5;2))

    Cheers,
    J

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: IF/AND Correct Score Predictor - Blank Before Data Entry?

    =IF(OR(C4="",D4="",I4="",J4=""),"",IF(OR((C4>D4)-(I4>J4);(C4<D4)-(I4<J4));0;IF(AND(C4=I4;D4=J4);5;2)))

    try above
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    01-19-2016
    Location
    Edinburgh
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: IF/AND Correct Score Predictor - Blank Before Data Entry?

    Excellent, thank you so much!

+ 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. [SOLVED] IF & AND Functions - Correct Score Predictor
    By johnmcluckie23 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-02-2018, 02:41 AM
  2. Need a Macro that enters a score if the correct conditions are met (File Attached)
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2015, 11:53 AM
  3. Problem transfering data from user form to correct blank row in column
    By hstarr2021 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-17-2013, 06:34 PM
  4. Replies: 2
    Last Post: 03-20-2012, 06:30 PM
  5. Comparison:get a correct score
    By :-) in forum Excel General
    Replies: 7
    Last Post: 02-18-2010, 10:12 AM
  6. Managing CORRECT data entry using cell validation
    By davecheng in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-15-2009, 08:59 AM
  7. How do I create drop down lists in Excel for correct data entry
    By Utpal Kapadia in forum Excel General
    Replies: 1
    Last Post: 01-21-2006, 10:30 AM

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