I have this code where I get the entire value from a division (for example, 50/3 = 16,67, not 16). But when try to work with 4 different cells (Ex/Fx and Gx/Hx, x as the last row number), for example (as the images below) If fill Ex and Fx (so Ix would be =SUM(QUOTIENT(Ex, Fx),(MOD(Ex,Fx)/Fx))) once, fill it twice (on the row above) and then try to fill Gx/Hx (so Ix should be =SUM(QUOTIENT(Gx,Hx),(MOD(Gx,Hx)/Hx))), it changes the value from the cell above, I mean, if it the cell above was =SUM(QUOTIENT(E3, F3),(MOD(E3,F3)/F3)) it will be =SUM(QUOTIENT(G3, H3),(MOD(G3,H3)/H3)).
What can I do to fix it? I guess it's a excel's thing. I don't know if can be fixed by excel settings or even do it with VBA.
6exlaZU.png
owVGoTf.png
NCUYqaw.png
I tried to use ISEMPTY (using with both group of cells, Ex/Fx and Gx/Hx), but it didn't work either.
Bookmarks