Hey I need to use both RANDBETWEEN and IF function in same cell? I have to generate random data, but if the cell value is 0 then I also need the random value to be 0..
First, do you realize that
RANDBETWEEN() function will generate new and new value every time when you open your workbook (and every time when you worksheet will be recalculated, e. g. by pressing Shift+F9 , so you will NOT have something as constant random value forever?
So suppose that the cell
A1 contains a value by which the random value is generated - if it is nonzero. Then the formula (in some other cell) will be
=IF(A1=0, 0, RANDBETWEEN(50, 60))