Hey,

I am just wondering if there is anyway to get my cells with if
statements in the to execute automatically. They are dependant on
other fields and I have an if statment that say 'if there is no value
do X if there is a value do Y' and it will not execute I have to double
click on the cell then hit enter and it will execute. Can you use loops
or anything in excel (As you can see I am not very familiar with excel)


--
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

Are you certain you don't have the calculation option (Tools - Options)
set to manual? My IF functions always calculate automatically.


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

Go to Tools Options. Calculation tab. Select Automatic under
calculation.

Mangesh


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

nope it is set to automatic...an other ideas why this might be
happening?


--
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

my cell that does simple multiplication occurs automatically...just the
ones with IFs don't


--
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

can you post your formula and the values in the concerned cell.

Mangesh


"matty_g" wrote in
message ...

my cell that does simple multiplication occurs automatically...just the
ones with IFs don't


--
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

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

Can you give us more detail? Specifics of the formula/spreadsheet?
What it actually does vs. what you expect it to do? Is this the same
spreadsheet that we turned iteration on to get your one IF function
working? Excel has an "evaluate formula" tool (Tools - Formula
Auditing - Evaluate formula) that may give some clues as to what your
problem is.

Just as a test, I put C7=IF(B7=1,"yes","no") into a spreadsheet.
B7=A5/B5. Everytime I change the values in A5 or B5, the IF function
evaluates. Of course, the function only returns "yes" when A5=B5, but
it will change from yes to no without any further prompting from me.
Can you set up a blank spreadsheet to do the same thing?


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