Problem with Formulas

  • Thread starter Thread starter Nick
  • Start date Start date
N

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)
 
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.
 
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
 
Nick said:
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).
Click to expand...
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.
Click to expand...
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).
 
Back
Top