Results 1 to 6 of 6

Update cells depending on an adjacent cells number

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2012
    Location
    Bristol
    MS-Off Ver
    Office 365
    Posts
    27

    Update cells depending on an adjacent cells number

    I have a spread sheet. I contains in one of the columns scores. I would like the text in the adjacent cell to automatically update with text, depending on the score in the original column.

    Eg If the score in H2 is 100, I’d like the cell I2 to say Full Compliance
    If H3 has a score of 84 I’d like I5 to say Substantial Compliance… and so on

    The scores are as follows

    100 = Full Compliance
    80 to 99 = Substantial Compliance
    41 to 79 – Limited Compliance
    40 or below = Little of No Compliance.

    Can someone help me with this?

    Many thanks

    D
    Last edited by debora; 07-13-2012 at 10:20 AM.

Thread Information

Users Browsing this Thread

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

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