portfolio

portfolio
click

networks

networks

INFORMATICA

INFORMATICA
discover this world

format

format
click

education

education
click

e difference

e difference
click

programs

programs
click

RANDOM (EXCEL) 11:32
Filed under:


RANDOM



Using this function returns a random number between 0 and 1. This function will return a random number between 0 and 1, it will always be greater than or equal to 0 and less than 1. It is important to note that each time the spreadsheet calculates returns a new number. The re-calculation of the leaf becomes that a change in the leaf which requires to calculate again or every time you press the F9 key.



STRUCTURE: = RANDOM ()




EXAMPLE




If we want to find a random value between 1 and 10, we write this function: = integer (RANDOM () * 10) +1. We must bear in mind that we only found aleatorio decimal values between 0 and 1. If you multiply by 10, we can have values between 0 and 9, to get an add values between 1 and 10. To remove the decimal point using the whole feature.

0 comentarios:

Publicar un comentario

Suscribirse a: Enviar comentarios (Atom)



© 2008 INTERACTIVE SYSTEMS
Design by Templates4all
Converted to Blogger Template by BloggerTricks.com