OK the thing is when i do a simple if like Mr. Shorty suggested it works
when I change the value of the cell in question the code gets executed.
I am not sure why this other code won't here is what I have and I will
explain what I would like to happen.

=IF(E290, IF(G290,G29,RANDBETWEEN(1,E29)), "0")

What I would like this to do is check if E29 = 0 if so then G29 = 0 as
well. If not then check if this cell has a value great then 0. If it
does, keep the value. If not then choose a random number between 1 and
the value of E29.

Hope this helps out a bit more. The thing is it works fine but it just
doesn't work automatically.


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