Thread: help with IF

not quite sure what your asking, uploading the sheet would help greatly (you can attach files in your post FYI)

i THINK your saying:

-you have a box with a sum of a bunch of stuff, lets assume its A1
-you have a second box that calculates points, lets assume B1, example: 1 in A1 = 1 point, 2 in A1 = 2 points, etc
-when the sum of A1 reaches 30, you want B2 to basically start over by applying the formula "A1-A1+1"

if thats the case, then you would do =IF(A1<31, A1,A1-A1+1)

this would continuously give you a count of "1" for whatever cell you put it in once A1 surpasses 30

but taht woudl cause an issue that you might not be wanting (again, not sure exactly what you want):
if A1 = 31, the cell would display 1
if A1 = 32, the cell would still display 1

the other thing i think u might be asking for is you want it so if A1 = 32, then the cell woudl read 2

if thats the case, you'll want this:
=if(A1<31, A1, A1-30)

this will count up to 30 points, then start over after the initial 30, you can combine more if statements to go past 60, 90, 120, etc etc

correct me over waht you want and i'll revise my answers