Hi All,

I am new here and hope you can help. I have a slighty unusual
requirement that I must create a single formula to do the work I need.
This is because it must simply be copied and pasted, then filled
downward. This is required to keep things extermely simple. I have
my formula doing most of what I want, but I would like to add a little
persistence to it. Well kind of anyway.

To simplify I basically want to roll a dice. Then use that number in
all the cells that I filled with my formula. Right now the dice roll
is in all cells and therefore is performed again for each. Not
acceptable. I figured I could use a name check to see if it was blank
then roll if it was and set it. And if not then use it. But I see
now way to do this in a formula.

Before you say "use a macro". Have the user load it, automatically
load it, etc... Not allowed.

You help is greatly appreciated.

Thanks,

Chris