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?
Bookmarks