Results 1 to 7 of 7

Conditional Value based on another cell

Threaded View

jcowley Conditional Value based on... 08-31-2010, 09:38 AM
zbor Re: Conditional Value based... 08-31-2010, 09:42 AM
jcowley Re: Conditional Value based... 08-31-2010, 10:13 AM
zbor Re: Conditional Value based... 08-31-2010, 10:19 AM
jcowley Re: Conditional Value based... 08-31-2010, 10:42 AM
zbor Re: Conditional Value based... 08-31-2010, 02:22 PM
jcowley Re: Conditional Value based... 09-02-2010, 09:24 AM
  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