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);"")
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.
- Hi, thank you again. I have been on vacation so didn't read this answar before today.
I have sent you the table in private message.