Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Try this

=ColorCheck() + INT(RND())

Functions such as RND(), NOW(), TODAY() are calculated when the data changes on the sheet and it will lead to a recalculation each of formulas in which they are included. INT(RND()) always equal zero. So, you can add this zero to result of your function

Try this

=ColorCheck() + INT(RND())

Functions such as RND(), NOW(), TODAY() are calculated when the data changes on the sheet and it will lead to a recalculation each of formulas in which they are included. INT(RND()) always equal zero. So, you can add this zero to result of your function

(But you will have TRUE0 for color

Try this

=ColorCheck() + INT(RND())

Functions such as RND(), NOW(), TODAY() are calculated when the data changes on the sheet and it will lead to a recalculation each of formulas in which they are included. INT(RND()) always equal zero. So, you can add this zero to result of your function

(But you will have TRUE0 TRUE0 for color 2302940!)

Try this

=ColorCheck() + INT(RND())
INT(RAND())

Functions such as RND(), RAND(), NOW(), TODAY() are calculated when the data changes on the sheet and it will lead to a recalculation each of formulas in which they are included. INT(RND()) INT(RAND()) always equal zero. So, you can add this zero to result of your function

(But you will have TRUE0 for color 2302940!)