function execution

[matty_g]

Hello,

I have a cell with an an if statement in it. The data in this cell is dependant upon other cells. The problem I am having is that I inorder to get the function to execute once I have entered data in the dependant cells, I have to double click on the cell then hit enter. Where as in other cells (example: a simple multiplication cell) it updates it automatically when the a cell loses focus. Is there anyway I can get this function to execute when a cell looses focus?

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Peo Sjoblom]

Tools>options>calculation set calculations to automatic

Regards,

Peo Sjoblom

"matty_g" wrote:

>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>
>

[Vasant Nanavati]

Are you sure you don't have calculation set to Manual (Tools | Options)?

--

Vasant

"matty_g" <[email protected]> wrote in
message news:[email protected]...
>
> Hello,
>
> I have a cell with an an if statement in it. The data in this cell is
> dependant upon other cells. The problem I am having is that I inorder
> to get the function to execute once I have entered data in the
> dependant cells, I have to double click on the cell then hit enter.
> Where as in other cells (example: a simple multiplication cell) it
> updates it automatically when the a cell loses focus. Is there anyway
> I can get this function to execute when a cell looses focus?
>
>
> --
> matty_g
> ------------------------------------------------------------------------
> matty_g's Profile:
http://www.excelforum.com/member.php...o&userid=23954
> View this thread: http://www.excelforum.com/showthread...hreadid=377525
>