Any Excel gurus here?

[Squeak 17]

Last year my substitute made an excel worksheet that self generates.
BUT
Some of the maths does not work the equations formula seem correct but the generated answrs are one or two numbers off
Any one know why?


Cell E7
=RAND()*100 (e.g. 82)
Cell E8
=RAND()*100 (e.g. 4)
Cell E9
=E7*E8 (answer generated 329) it SHOULD be 328

any ideas?

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?

[kj126 0]

Right click cell9 -format cell- use the number tab, and see how many decimal points its using.

I Am Sofa King We Todd Did!!

[quade 4]

Or you could fix it with;

=ROUND(RAND()*100,0)

quade -
The World's Most Boring Skydiver

[shropshire 0]

There are a number of EXCEL rounding formulae...

This may help ... http://www.digdb.com/excel_add_ins/round_up_down_rounding/

(.)Y(.)
Chivalry is not dead; it only sleeps for want of work to do. - Jerome K Jerome

[Squeak 17]

Quote

There are a number of EXCEL rounding formulae...

This may help ... http://www.digdb.com/excel_add_ins/round_up_down_rounding/

cool
thanks guy, i replaced the formulae with a rounded
INT(RAND()*100)
that seems to work much better.


From what i can gather, the RAND command will only display the truncated number but the formula was using the complete number (e.g. displaying 84, but using 84.3509)
prefixing with INT only allows integers to be used in the Random selection.
Thanks

You are not now, nor will you ever be, good enough to not die in this sport (Sparky)
My Life ROCKS!
How's yours doing?