Results 1 to 4 of 4

If function, false, blank.... need help!!

Threaded View

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    NB, Canada
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    2

    If function, false, blank.... need help!!

    CC rubric.xlsThere is my problem:

    I have an evaluation sheet with 2 main columns (column A, column B), which I will fill with sentences from another sheet using IF function unless there’s something better.

    My other sheet is working like this:

    I have to attribute a score (1 to 5), and each score have a sentence attach to it… So for scores 1 and 2, I want those sentences to go in column B, AND 3, 4, 5, goes in column A.

    I have 25 blocks that I have to put scores 1 to 5.

    So I’m looking for:
    - each sentences to go in their respective column (A or B);
    - if a sentence is in column B, I want a blank in column A, BUT if I put another sentences in column A, I don’t want a big BLANK space before.
    - I want the sentences in each column to follow each others like normal text.
    - I have to print 2 sided sheets, so if one side is full, I want it to go on the other side.

    It’s a lot to ask, but I need an expert, because I’m stuck!!

    Thank you
    Last edited by flec011; 03-20-2012 at 09:19 AM.

Thread Information

Users Browsing this Thread

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

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