I am reviewing someone else's work without them being easily able to answer. The formula below should not produce results less than zero as it is related to a physical quantity that cannot be negative. However it is:

```
=IFERROR(IF(((RAND()-0.5)*J6*I6)<0,0,(RAND()-0.5)*J6*I6),0)

```

Both the column "J" and "I" numbers are all positive. I assume it is because the two `RAND()` functions are separate from each other and therefore are in fact two different random numbers each time it calculates. Is this the case?

In which case a separate column with the `RAND()` functions and this one referencing them would work?