Calculating with displayed values

[Tobit]

I have two cells, each displaying numbers to with 2 decimal points

Cell A1 contains the number 15.333333333 (the figure the result of a
calculation)

Cell A2 contains the number 15.33 (the figure is input by the user)

Both will display 15.33

I want to set up cell A3 to warn me if there is a difference in the
displayed values

If I use =IF(A1-A2=0,"","check!"), it will always show check!, because the
actual values of A1-A2 is not 0

How do I adjust the formula so the calculation is between the displayed
values (i.e. 15.33-15.33 = 0) not the actual values ?

Many thanks

--
Tobit Curteis
________________________________

Tobit Curteis Associates
36 Abbey Road
Cambridge
CB5 8HQ
UK

Tel: +44 (0)1223 501958
Fax: +44 (0)1223 304190
E-mail: (e-mail address removed)
Web: www.tobit-curteis-associates.com

 

[Niek Otten]

use the TEXT() function. Look in HELP for details. Something like

=IF(TEXT(A1,"0.00")=TEXT(A1,"0.00"),"","check")