+ Reply to Thread
Results 1 to 7 of 7

Conditional formula question

  1. #1
    Registered User
    Join Date
    01-07-2005
    Posts
    45

    Conditional formula question

    Hey, thanks in advance for taking the time to read and possibly helping me solve this issue...

    What I am doing is I am trying to create a formula that will make it simple for me to update a spreadsheet that has changing rankings of a set. Each rank has a value it receives based on a formula (so if it is ranked #1, it is 1*45000, if it is #2 it is .975*45000, and so on)

    I would like to set a formula that will determine what the cell should be without having to link each cell to the correct formula (or number)

    So, basically...I'm wondering if there is a way that you can have a formula that will look at one cell, and based on that cells value it will select what of the different optional formulas I want.

    ------------------------------------------------------

    Let me explain it again from another angle, because I'm not great with explaining my needs...

    I'm trying to get a formula, lets say its for cell B1...I'd like it to look at cell C1 and if C1=1, it should use the formula $D$1*$E$1. If C1=2, it should use the formula $D$2*$E$1. If C1=3, it should use the formula $D$3*$E$1, and so on.

    I'm assuming there is some way to do this, I just don't know how to begin looking and I am not the best at coding such things.

    Once again, thank you very much for taking the time to read and possibly any advice/answer you can provide to this question!

  2. #2
    Registered User
    Join Date
    01-07-2005
    Posts
    45
    Also...another question that goes along with this original one but isn't as complicated...

    On the same spreadsheet I have a set of cells that are linked to the rankings list. I'd like to keep the rankings list numbered from 1-32 but when I reorganize them the cells don't follow where the last name was. So, basically is there a way to have cell F1 (for example) to link or reconnect easily to cell the value from A1 if the name in A1 moves down to A3 (for example) as well as B1 which would move along with A1 to B3.

  3. #3
    Registered User
    Join Date
    01-07-2005
    Posts
    45
    Nevermind about the original post, I actually had an epiphany and came up with a simple method, although a bit of a cheating way, it'll serve the purpose.

    If anyone can come up with an easy way to solve the 2nd issue (2nd post I made) that would be very much appreciated.

  4. #4
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302
    Does this answer part of your question? As for the second question, it would help to post your worksheet so far.

    Please Login or Register  to view this content.
    FrankBoston is the pen name for Andrew Garland, Lexington MA

  5. #5
    Registered User
    Join Date
    01-07-2005
    Posts
    45
    Doing it as fast as possible...here's a screenshot of it...

    basically, the Bears from Z2 I want to follow the cell that says Bears in A6, as well as the rest in the colored section on the right side...When I sort the area on the left so it has the rankings from column E, these cells won't follow the names, but stay at the current cell...

    Link to Screenshot

    Thanks a lot for the quick reply

  6. #6
    Registered User
    Join Date
    01-07-2005
    Posts
    45
    Any ideas on what to do for the last post?

    Thanks!

  7. #7
    Forum Contributor
    Join Date
    07-05-2007
    Location
    Lexington, MA
    Posts
    302

    The workbook is everything

    I didn't understand the screenshot. I suggest that you zip and upload an example workbook, with comments explaining what you have, what you want, and what the problem is.

+ Reply to Thread

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