Formular Challenge

S

standardF

New member
Joined
Jun 17, 2019
Messages
3
Reaction score
0
Points
0
Excel Version(s)
2016
Dears, I'm trying to achieve round up based on 0.3 multiples so that if I sum up variables, the decimal values should be round up to 0.3 multiples and remainder values returned.
Example
A
B
C
SUM
Desired Output
1.21
1.29
1.27
3.77
5.17

The formular I used is not working. =ROUND(A59,0) + IF(MOD(A59,1)>=0.3,1,0)
Response I got is 5 with no remainder value returned.
Please help out gurus in the house
 
click or tab into the cell with the formula,
from the Formulas Ribbon, Formula Auditing section, click Evaluate Formula,
you can now step through the formula and see what Excel is working with and the result of each part,
maybe you'll notice something other than what you expect.
 
Thanks NoS but I can't find a way around this
 
If that 5.17 is really the Desired Output... I have no idea.
If the Desired Output should be 3.9 then try
=INT(D59) + CEILING(MOD(D59,1),0.3)

edit: added this comment
I do see a problem when the remainder is greater than .9
hopefully one of the formula guys can assist with this issue.
 
Last edited:
Thanks NoS. The desired output is 5.17.

Gurus in the house please help out
 
I don't understand the logic behind 5.17

Can you explain how you sum 1.21+1.29+1.27 and receive 5.17?
 
You must log in or register to reply here.
Back
Top