Generate value depending on the 5 digit decimal numbers

[hsandeep]

Range C3:C8 generates numerical values which are decimal numbers or 0. These decimal numbers have 5 digit whole numbers and fractional part.
D2= generates numerical values
E2= generates numerical values

Output range F3:F8 required such that
Example for C3 (42583.569)
IF ceiling(C3,E2)<=C3+D2, then C3=E2+ceiling(C3,E2)
IF ceiling(C3,E2)>C3+D2, then C3=ceiling(C3,E2)
& so on for C4:C8
How to accomplish?
Thanks in advance.

Book2.xlsx
	C	D	E	F
2		20	100
3	42583.569			42700.000
4	42987.230			43100.000
5	42950.000			43000.000
6	42980.000			43100.000
7	43000.000			43100.000
8	42220.000			42300.000
Sheet2

 

[ExceLoki]

try this
----------

Book1
	C	D	E	F
2		20	100
3	42583.569			42700.000
4	42987.230			43100.000
5	42950.000			43000.000
6	42980.000			43100.000
7	43000.000			43100.000
8	42220.000			42300.000
Sheet1

Cell Formulas
Range	Formula
F3:F8	F3	=IF(CEILING(C3,$E$2)<=C3+$D$2,($E$2+(CEILING(C3,$E$2))),(CEILING(C3,$E$2)))

 

[Eric W]

Same basic idea:

Book1
	A	B	C	D	E	F
1
2				20	100
3			42583.569			42700.000
4			42987.230			43100.000
5			42950.000			43000.000
6			42980.000			43100.000
7			43000.000			43100.000
8			42220.000			42300.000
Sheet4

Cell Formulas
Range	Formula
F3:F8	F3	=CEILING(C3,$E$2)+IF(CEILING(C3,$E$2)<=C3+$D$2,$E$2)

 

[hsandeep]

Same basic idea:

Book1
	A	B	C	D	E	F
1
2				20	100
3			42583.569			42700.000
4			42987.230			43100.000
5			42950.000			43000.000
6			42980.000			43100.000
7			43000.000			43100.000
8			42220.000			42300.000
Sheet4

Cell Formulas
Range	Formula
F3:F8	F3	=CEILING(C3,$E$2)+IF(CEILING(C3,$E$2)<=C3+$D$2,$E$2)

Thanks Eric W Your formula works & meets my requirement. Very nice approach "Short & Accurate".

 

[Phuoc]

Another way

=CEILING(C3+$D$2+0.00001,$E$2)

 

[hsandeep]

Another way

=CEILING(C3+$D$2+0.00001,$E$2)

Superb..I liked the 'mathematics' involved in the formula (use of 0.00001). Thanks Phuoc