Hello All,

I want to create custom RANDBETWEEN function to stop excel from recalculating with every click. I want to make it work for this formula.

=IF(NOT(ISBLANK(B3)),RANDBETWEEN(15,1506009),"")

Please help. Thanks