Sum with condition

[dado6612]

Hi to all
I made a table which from users inputs calculate daily growth of skill.
Each 250 points he get reward
I made a formula which will say is 250 points reached by this:
=IF(ROUNDUP(A1/250;0)>ROUNDUP(A2/250;0);"Yes";"No")
(maybe there is simpler formula)

Now I want in column B number of days between two rewards
ex.
Daily growth is 16.5
day 1 - 16.5 skill points
day 2 - 33
.....
day 15 - 247.5
day 16 - 264 - Day of reward
next reward is at day 31 and so on
Basically I want in same row to show number of day passed since last reward till next one
so, in B17 it would be 16
B32 15 and so on..

Hope you understand and know how to help
Thanks

 

[GlennUK]

You are asking something very confusing here ..."show number of day passed since last reward till next one" ... is that :

a) show number of days passed since last reward

or

b) show number of days till next reward

?

 

[dado6612]

a) show number of days passed since last reward
But now you gave me idea to use b) show number of days till next reward also
if you can to help in both cases

 

[GlennUK]

Look at this and see if it's close to what you want:

Excel Workbook
	A	B	C
1	16.5	0	15
2	33	0	14
3	49.5	0	13
4	66	0	12
5	82.5	0	11
6	99	0	10
7	115.5	0	9
8	132	0	8
9	148.5	0	7
10	165	0	6
11	181.5	0	5
12	198	0	4
13	214.5	0	3
14	231	0	2
15	247.5	0	1
16	264	0	15
17	280.5	1	14
18	297	2	13
19	313.5	3	12
20	330	4	11
21	346.5	5	10
22	363	6	9
23	379.5	7	8
24	396	8	7
25	412.5	9	6
26	429	10	5
27	445.5	11	4
28	462	12	3
29	478.5	13	2
30	495	14	1
31	511.5	0	15
32	528	1	14
33	544.5	2	13
34	561	3	12
Sheet1

 

[dado6612]

That's it, thank you a lot

 

[GlennUK]

That's great!