Problem with Formulas

[Nick]

When I do an IF-statement, or use VLOOKUP, etc. I receive
an arror. The same formula works perfectly on another
machine (same configuration, software everything the
same).

I have phoned Microsoft here in South Africa about the
problem. The people they referred me too, cannot help me.

Let me give you an example of my problem:

A1 50
A2 100
A3 150

Formula in B1: =IF(A1>100,"PASS","FAIL") The values
in the A-column are formatted to number. Let me just
stress again that the same formula works perfectly on the
other machines. I have tried re-installtation, it gives
the same problem.

Please help.

Nick

27 82 7955682
27 21 906 4777
27 21 987 0245
(e-mail address removed)

 

[Norman Harker]

Hi Nick!

Maybe the numbers are still text. If they are text you should see a '
before the number. No amount of changes to format will stop them being
text.

 

[Stephen Dunn]

The error doesn't happen to say FAIL does it?

Seriously though, what is the error?

 

[Harald Staff]

Nick

Try
=IF(VALUE(A1)>100,"Y","N")
to overcome possible text entries.
Ensure also that calculation is set to Automatic in Tools > Options.

HTH. Best wishes Harald

 

[Markus L]

When I do an IF-statement, or use VLOOKUP, etc. I receive
an arror. The same formula works perfectly on another
machine (same configuration, software everything the
same).

Specify what exactly you mean by "error"?
Error message? Incorrect result?

A1 50
A2 100
A3 150
Formula in B1: =IF(A1>100,"PASS","FAIL") The values
in the A-column are formatted to number. Let me just
stress again that the same formula works perfectly on the
other machines. I have tried re-installtation, it gives
the same problem.

2 ideas:
1. Select column A; Data > Text to Columns > Finish
2. Control Panel > Regional Options (or similar, depends on your OS) >
Numbers; Check that "List separator" is "," (comma).