Hello,

I have a function which checks for data in a certain field if data is
in the field I want my function to do nothing and the value currently
in the field to stay there, however; if there is not data in the field
I would like a random number to be chose. The problem I am having is
when the function is false I don't know how to just keep the same value
when I do it like this:

=IF(A3="",(RANDBETWEEN(1,E2)))

it fills the field with FALSE, if the value is false there will be data
in this field already and I want that data to remain there. Any idea?

Thanks for your help!!


--
matty_g
------------------------------------------------------------------------
matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
View this thread: http://www.excelforum.com/showthread...hreadid=375800