dynamic rounding formula

[tomishere]

Hello,

Been trying to figure this and I feel I am close but there also may be an easier way to do this..

Pretty much if the summed value's two digits after the decimal is greater or equal to .90 and less than or equal to .99 then round up else keep the number as is. So 1.91 should be 2 and 1.89 should be 1.89, 2.96 should be 3 and 2.67 should be 2.67.

This is what I have
=IF(AND(LEFT(SUM(A2,B2),2)&RIGHT(SUM(A2,B2),2)>(LEFT(SUM(A2,B2),2)&90),RIGHT(SUM(A2,B2),2)<(LEFT(SUM(A2,B2),2)&99)),ROUNDUP(LEFT(SUM(A2,B2),2)&RIGHT(SUM(A2,B2),2),2),LEFT(SUM(A2,B2),2)&RIGHT(SUM(A2,B2),1))

I am trying to make this dynamic so my logic is get the right two digits of the summed value and concatenate 90 and 99 when doing the >=, <= and using the roundup function if it meets the criteria else just display the summed value. If there is an easier way to do this please show me the way

 

[Peter_SSs]

Edit: I misread your formula but does it do what you want if you replace A1 in the formula below with SUM(A1, A2)?

Does this do what you want?

Book1
	A	B
1	1.91	2
2	1.89	1.89
3	2.9	3
4	12	12
5	3.01	3.01
6	2.99	3
Round above 0.9

Cell Formulas
Range	Formula
B1:B6	B1	=IF(MOD(A1,1)>=0.9,ROUNDUP(A1,0),A1)

 

[tomishere]

Edit: I misread your formula but does it do what you want if you replace A1 in the formula below with SUM(A1, A2)?

Does this do what you want?

Book1
	A	B
1	1.91	2
2	1.89	1.89
3	2.9	3
4	12	12
5	3.01	3.01
6	2.99	3
Round above 0.9

Cell Formulas
Range	Formula
B1:B6	B1	=IF(MOD(A1,1)>=0.9,ROUNDUP(A1,0),A1)

 

[tomishere]

Hi Peter,

This is what I needed. Yep, just replacing the A1 with the sum did it. Really appreciate it, thank you.

- Thomas

 

[Peter_SSs]

Hi Peter,

This is what I needed. Yep, just replacing the A1 with the sum did it. Really appreciate it, thank you.

- Thomas

You are very welcome. Thanks for the follow-up.