Let's say we I have in A1 42.14,in A2 5.02 and in A3 A1+A2, A3 will be equal to 47.16. I want to round the second decimal of A3 to 0 or 5 the closest one changing A2.
In the example A3 shoulb be 47.15 so I want that A2 automatically changes to 5.01
Any ideas????
Thanks.
In the example A3 shoulb be 47.15 so I want that A2 automatically changes to 5.01
Any ideas????
Thanks.