Evan,

Can't offer much help as I don't have Excel 2003, but it does sound strange.

Perhaps someone else has experienced this and understands it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
Thanks, this solved the problem. Strange though, I have been using this
spreadsheet for years. The user enters a total value, which is stored as a
variable. The user then enters a subtotal, and is given the difference
between the total and the subtotal to confirm. It is then stored as
another
variable. The numbers are ALWAYS whole numbers, or numbers with two
decimal
places. I have not run into this problem with thousands of transactions.

For what it's worth, this was all written in Excel 2000. I upgraded to
Excel
2002 and used it with no trouble for a couple of years with no problem. I
recently upgraded to Excel 2003. I can no longer use the file in 2000 or
2002 since saving it as 2003 because I get a lot of "object not found"
messages for code that I have not changed.

"Bob Phillips" wrote in message
...
Try

?Round(salecomm,2) = 1228.95

it is probably because the actual value is 1228.95243357 or something,
but
only showing 2 dec places.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Evan" wrote in message
...
I have a form that compares the total values of several fields to a
variable
value when the user clicks the Submit button. The fields need to equal
the
variable value or the form will not be submitted. I ran into a problem
where
the fields DO appear to equal the variable value, but excel says
no....In
the immediate window, I type ?salecomm and get 1228.95. I then type
?salecomm = 1228.95 and get back FALSE. I cannot seem to duplicate
this
problem with other random numbers. I get back TRUE when using other
values.
I obviously have not tried every value, but I am lost for now. Any
ideas
where I might start?

Thanks