+ Reply to Thread
Results 1 to 7 of 7

Excel Logic

  1. #1
    Registered User
    Join Date
    04-13-2012
    Location
    New Paltz, New York
    MS-Off Ver
    Excel 2003
    Posts
    9

    Excel Logic

    Hello, I have an excel spreadsheet that I am making and one requirement is that I want every increment of 5 to raise the value of the cell by $1.

    So at 0 = $0
    1=$0
    2=$0
    3=$0
    4=$0
    5=$1
    6=$1
    7=$1
    8=$1
    9=$1
    10=$2
    11=$2
    etc

    so for every multiple of five you would increase the cell by $1. How would I make that into a formula. I could just make a ton of if statements but because I only can make i think 60 statements then i could only go up 300 points (60 times 5)

    Is there a statement that says something like for every 5increment of 5 raise the total by 1?

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Excel Logic

    Assuming you have a starting point somewhere (B1 for example), link starting point to B1, and starting row 2 enter formula like this =IF(MOD(ROW(A2),5)=1,D1+1,D1) then drag it down
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-13-2012
    Location
    New Paltz, New York
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Excel Logic

    hmm...im new to this forum...how do i put an excel file on here like you did for me

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Excel Logic

    Click on Go Advanced, scroll down to manage file I think

  5. #5
    Registered User
    Join Date
    04-13-2012
    Location
    New Paltz, New York
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Excel Logic


  6. #6
    Registered User
    Join Date
    04-13-2012
    Location
    New Paltz, New York
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Excel Logic

    So in that file you put a number in the top....it makes the same number appear below it and every 5 points you earn $1....so how do i apply that formula you gave?

  7. #7
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Excel Logic

    I don't know what I am looking at. Can you explain your question clearly?

+ 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