+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS Nested if then Else - Colour in Blank Cells in Technical; Hi all, sorry if this has been posted elsewhere, I did do a quick check! I'm setting up some traffic ...
  1. #1
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Nested if then Else - Colour in Blank Cells

    Hi all, sorry if this has been posted elsewhere, I did do a quick check! I'm setting up some traffic light analysis in SIMS using the Nested if then Else formula. When i calculate the data in the marksheet, it will colour in blank cells as well. Can i do anything in the template to ignore or not colour blank cells?
    Thanks!
    Lianne

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,970
    Thank Post
    673
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    What does your formula tell it to do? Is it treating them as zero? Maybe add a final condition if anything else leave colourless.

  3. #3
    LianneKemp's Avatar
    Join Date
    Apr 2012
    Location
    Solihull
    Posts
    20
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for replying, I actually worked out that is was my gradeset - I had a grade of 'N' which had a value of 11. I've amended my gradeset since and it works fine!

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 9
    Last Post: 7th June 2013, 10:55 AM
  2. [SIMS] Checking If Marksheets are complete in SIMS
    By chrisateen in forum MIS Systems
    Replies: 14
    Last Post: 15th May 2013, 01:14 PM
  3. [SIMS] SIMS - back ground colours in Windows 7
    By split66 in forum MIS Systems
    Replies: 6
    Last Post: 9th December 2011, 10:34 AM
  4. [SIMS] Nested IF statements
    By philserre in forum MIS Systems
    Replies: 12
    Last Post: 21st November 2011, 08:46 AM
  5. [Powershell] IF THEN ELSE
    By box_l in forum Scripts
    Replies: 4
    Last Post: 23rd February 2011, 02:41 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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