Results 1 to 6 of 6

Help hiding cell value prior to info input

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2017
    Location
    America
    MS-Off Ver
    2013
    Posts
    3

    Help hiding cell value prior to info input

    Hey guys, I have scoured endlessly to try and figure this out on my own, but nothing is working yet and it's driving me crazy. I'm trying to make a list with 9 questions with a "Yes, No, or Partial" answer with a 100, 50, or 0 attached to each answer, then at the end of the list, take the total sum of the points/answers and divide them by the amount of questions asked so that I can find the average, then assign a grade letter based on the number results. So far so good, my only problem is that before I start and begin answering any questions, the letter "A" shows up instead of just a blank cell like I want, at least until one or more questions have been answered.

    This is my formula I'm using, and the grading is working properly, just not the show blank cell if nothing is answered yet part.

    =IF(D27>=90,"A",IF(D27>=80,"B",IF(D27>=70,"C",IF(D27>=60,"D",IF(D27>=10,"F",IF(D27<=1,""))))))
    ;the red coding is what I made to attempt to hide a value below 10, but it's not working and still shows an "A" grade before any questions have been answered.

    Screenshot of the project for reference
    \1

    I very much appreciate any help anyone can offer with this issue. It's really not a major problem, I would just really like to figure it out. You'd think something like this would be incredibly simple to figure out.
    Attached Files Attached Files
    Last edited by Shulbocka; 02-21-2017 at 03:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup formulas are locked. Can I use wildcards * in input cell to find info?
    By billisnice in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2017, 10:47 PM
  2. Replies: 1
    Last Post: 02-26-2015, 06:12 PM
  3. multiply by info in different columns, selected by input in cell
    By andbjo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 03:02 PM
  4. Input Box based on Another Cell Info Macro
    By jnwel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2012, 02:19 PM
  5. Replies: 11
    Last Post: 09-26-2011, 11:29 AM
  6. Userform to Search Prior Input Data
    By riosaaron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2011, 10:22 AM
  7. returning something in a cell if another cell has info input
    By stevesunfold in forum Excel General
    Replies: 14
    Last Post: 04-01-2008, 08:51 AM

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