Forum Discussion
Formulas automatic every fifht row
The MOD function is REST in Norwegian, and SUM is SUMMER.
HansVogelaar, than you very much.
I was aware of that (different function languages) but so opsessed about trying both in norwegian and english and did't see it was mixed up, so thank you so much. I am a totally novice in this.
I got i right now in the test table, but still struggeling with automatic copying to the 600 other rows.
The attachements "Formula_01" is showing that the formula is calculating the right answar.
The second picture "Formula_02" is showing one formula =HVIS(SUMMER(K16:K19)>M19;AVRUND(SUMMER(K16:K19)-M19;5)) that I want to copy exsactly the same (but every fifth row), but it does not function. I don't understand how to combine the two formulas to get it right.
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);"")
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
That way I could experiment, and the formulas would automatically be translated from Norwegian to English and back.