Hi,
I am attempting to make a maths worksheet that generates random maths sums but I don't want two sums in a row to have the same question (I want the same sum to appear later, just not twice in a row). Is this possible with a simple excel formula? I have been trying to put RANDBETWEEN(1,5) into an IF statement but I have not been having much luck...
I am attempting to make a maths worksheet that generates random maths sums but I don't want two sums in a row to have the same question (I want the same sum to appear later, just not twice in a row). Is this possible with a simple excel formula? I have been trying to put RANDBETWEEN(1,5) into an IF statement but I have not been having much luck...