Results 1 to 7 of 7

Conditional Value based on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2010
    Location
    Brighton, UK
    MS-Off Ver
    Excel 2003
    Posts
    24

    Conditional Value based on another cell

    Hi All,

    I am making a scorecard, and if a cell is above 30%, I want the cell next to it to score 5 points, and if the cell is below 30%, I want it to score 2 points. Is this possible?

    I have attached a spreadsheet to show you the layout.

    Many thanks
    Attached Files Attached Files

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