maths problems

Originally Posted by martindwilson

it would never work. .randbeween(1,10)&"+"&randbeween(1,10) which can be evaluated would change as soon as a value is entered in col b
ie 1+9 which we know =10 but if you put 10 in col b the randbetween() would recalculate and could become say 3+6 so 10 would now be wrong

And the solution is a macro that copy the random result to the cell as values