Answer:
False
Explanation:
The RAND() function returns a different number every times you hit F9 or open the Spreadsheet. So, if you have multiple RAND() statements then you'll get different numbers.
=IF(RAND()<$C$8,$B$8,IF(RAND()<$C$5,$B$5,IF(RAND()<$C$7,$B$7,$B$6)))
