Is there a worksheet function that will..

[Adam Kroger]

Is there a worksheet function that will copy (or return) the value of
another cell (not its formula)

I want to have a cell with an IF statement that when true will show what the
current RAND() number is as a number only. ie
IF(A1="Y",COPYasVALUE($B$3),"")

of course COPYasVALUE is not a realy existing function in excel.

The end result I am trying to accomplish is to fill a range of cells with a
non-volitile randomly determined number, when a condition is met.

 

[Randall.Senn]

Adam,

There is no such function.

I suggest that after the first calculating the numbers, you do an
Edit > Copy and Edit > Paste Special > Values operation onto the
numbers to make them non-volitile.