I am experiencing a problem with Excel, when using the "IF"-function. Even
previous files, which used to work on my previous computer (and therefore my
previous Excel) now don't want to use the "IF"-function correctly. The same
happens when I use the examples created by Microsoft in their Help Database.
It is obvious that there is some kind of an inherent/built-in problem with my
version of Excel.
Attached find a snapshot of a VERY SIMPLE calculation, which serves to show
that the function is not working correctly.

Try ToolsOptions, Calculation tab, set Calculation to Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Fanzo" wrote in message ...
|I am experiencing a problem with Excel, when using the "IF"-function. Even
| previous files, which used to work on my previous computer (and therefore my
| previous Excel) now don't want to use the "IF"-function correctly. The same
| happens when I use the examples created by Microsoft in their Help Database.
| It is obvious that there is some kind of an inherent/built-in problem with my
| version of Excel.
| Attached find a snapshot of a VERY SIMPLE calculation, which serves to show
| that the function is not working correctly.
|

Your attachment did not attach and please don't use attachments in
newsgroups. Explain what you have including the dependent cells. Include
the function. Describe what you want this function to do. Describe what
this function actually does. HTH Otto
"Fanzo" wrote in message
...
I am experiencing a problem with Excel, when using the "IF"-function. Even
previous files, which used to work on my previous computer (and therefore
my
previous Excel) now don't want to use the "IF"-function correctly. The
same
happens when I use the examples created by Microsoft in their Help
Database.
It is obvious that there is some kind of an inherent/built-in problem with
my
version of Excel.
Attached find a snapshot of a VERY SIMPLE calculation, which serves to
show
that the function is not working correctly.