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
Response I got is 5 with no remainder value returned.
Please help out gurus in the house
Example
The formular I used is not working. =ROUND(A59,0) + IF(MOD(A59,1)>=0.3,1,0) |
Please help out gurus in the house