Not equal to?

[Evan]

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

 

[Bob Phillips]

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]

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]

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)

 

[Jerry W. Lewis]

The "object not found" error has nothing to do with the code. Rather it
has to do with the infrastructure required to run VBA. Copy the VBA
code to Notepad and delete the modules. Then in Excel 2000 insert
modules and past the code from Notepad.

I have seen no evidence that the numerics have changed in 2003. I use
all three versions (Excel 2000, 2002, and 2003) if you want to post the
code (text only, not attachments).

Jerry