My "IF FUNCTIONS" on excel worksheet do not work

F

Fanzo

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

Niek Otten

Try Tools>Options, Calculation tab, set Calculation to Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Otto Moehrbach

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
 
Top