Results 1 to 6 of 6

need help calculating based on a given grade.

Threaded View

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Dominica
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question need help calculating based on a given grade.

    A1 = $1, B1 is a grade from 6-9, C1 is a total.

    6 = 50%, 7= 100%, 8= 150%, 9=200%
    or 6=1.5, 7=2, 8=2.5, 9=3

    example if a grade of 8 was given, 100% of $1 would be added to the based which is A1 making C1=$2

    I wanted a formula for C1 that would lookup the grade in B1 and then multiple the grade percentage by A1.

    I want to be able to change grades freely so the formula should be in C1. any help would be appreciated.
    Last edited by nasser4life; 05-08-2013 at 09:30 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