Forum Discussion
Formulas automatic every fifht row
Does this do what you want?
=HVIS(MOD(RAD();5)=0;AVRUND(STØRST(SUMMER(K16:K19)-M19;0);5);"")
HansVogelaar, thank you for your patience with me.
I think you mixed up the function with both english and norwegian, you too? 😉
=HVIS(MOD(RAD();5)=0;AVRUND(STØRST(SUMMER(K16:K19)-M19;0);5);"")
If I change the 'MOD' to 'REST' and change from '=' to '>' the calculate get accactley.
With the '=' I got it wrong. Nothing shows in the cell.
But I can not find a way to get it automatic filled in to the other cells down under. I have tried to mark all cells in one collone, and ctrl + D as sombody told me to. I have also tested to pull the cross down, because the formula should be able to calculate then, like it does in the test table.
Pic under show the formuls give the accurate number, but it also give al lot of other cels between filled with (random) numbers.
=HVIS(REST(RAD();5)>0;AVRUND(STØRST(SUMMER(K16:K19)-M19;0);5);"")